Re: Moving Emerald Database

Kurt White ( kurtw@iea.com )
Tue, 29 Jul 1997 09:56:21 -0700

In the SQL Enterprise Manager sub-window Server Manager,
expand the server you want to transfer from,
expand the databases folder,
right click on Emerald,
select Transfer

Kurt

David Edwards wrote:

> 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?
>
> David Edwards
> Oakweb.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com

--Kurt WhiteIEA Software Inc. - Emerald - RadiusNT -http://www.iea-software.com