Re: moving Emerald database

David Khoury ( dave@flex.com.au )
Fri, 13 Jun 1997 19:32:28 +1000

>I set up SQL Emerald on a test server so our accounting dept. could check
>it out and before I knew they had 500 accounts put in. This being a test
>server there is only a 600mb drive thats out of space and they don't want
>to enter the information in again.
>How do I move the database or back it up and restore it I know little about
>SQL.

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
--------------------------------------#------------------------------------