The easiest way to move it is to just do a transfer. With Enterprise
Manager, reate an Emerald database on your new server, right click it,
select "Transfer", select the right Server/Database in the Source section,
then start the thing.
DONT start the transfer from the source server. Start it from the
destination. I don't know if this is a bug, but when I did this once, all
the data was erased from my SQL server and nothing was transferred to my
destination. And I double checked everything before I clicked on the
transfer button. Luckily I did a manual dump of the database only a few
hours before.
--------------------------------------#------------------------------------
David Khoury | "Where's the KABOOM ??
Technical Manager & Comms Engineer | There was supposed to be an
dave@flex.com.au | earth shattering KABOOM!!"
http://www.flex.com.au/~dave | Marvin the Martian
--------------------------------------#------------------------------------