Re: Moving Emerald Database
David Edwards ( Gecker@Oakweb.com )
Thu, 24 Jul 1997 22:11:55 -0700
At 12:15 PM 7/24/97 -0700, you wrote:
>Justin Brown wrote:
>> I am going to be moving my Emerald Database from one server to another.
>> The database was originally created with an old version of Emerald.
>> Should I use the scripts to create a new database and then move the data
>> over, or should I just use the Bulk Copy to move the information?
>Unless your current database has problems, I would just use SQL
>Enterprise Manager to do a Database transfer, which will transfer
>all objects, users, permissions, etc. I do this all the time
>between servers to replicate databases so that I can hammer on a
>copy of the database.
What command do you use in Enterprise Manager to do this? Does this leave
the existing database in tack and functional?