Wednesday, March 21, 2012

Migrate MSDE 2000 to SQL 2000

I would like to know how I can move current MSDE 2000
database to SQL 2000 database. I want to put all
databases on my 1 SQL server.
Thanks.
The simplist way to do this is to backup and restore the databases to your
new server. You will then need to add any SQL Server logins to your new
server that are users in your databases. Then run sp_change_users_login (see
BOL) to synch the database users with the logins.
Jim
"SQL_Newbie" <anonymous@.discussions.microsoft.com> wrote in message
news:12dc01c50419$1e354bf0$a601280a@.phx.gbl...
>I would like to know how I can move current MSDE 2000
> database to SQL 2000 database. I want to put all
> databases on my 1 SQL server.
> Thanks.

No comments:

Post a Comment