sql server msde: Move a MSDE to SQL 2000 -- sql server msde

You're in the

sql server msde

group:

Move a MSDE to SQL 2000

Re: Move a MSDE to SQL 2000

Jacco Schalkwijk
11/25/2004 4:32:29 PM

sql server msde: You can just make a backup of the database on MSDE and restore that on the
SQL Server. That is all there is to it, assuming MSDE and SQL Server are
both the same version (i.e. both 7 or both 2000).

--
Jacco Schalkwijk
SQL Server MVP

[quoted text, click to view]

Move a MSDE to SQL 2000

Eduardo Crespo
11/25/2004 5:09:33 PM

Hi

My problem is that I have a MSDE database in one server and I want to move
it to an SQL Server in another server. Can anyone tell me what procedure do
I have to follow?

Thanks in advance

Re: Move a MSDE to SQL 2000

Eduardo Crespo
11/25/2004 5:42:43 PM

Thanks a lot Jacco

"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid>
escribió en el mensaje news:Om2zaxw0EHA.3120@TK2MSFTNGP12.phx.gbl...
[quoted text, click to view]

RE: Move a MSDE to SQL 2000

girishs NO[at]SPAM microsoft.com
11/25/2004 8:27:39 PM

Hi ,
Any of the following methods can be used to move msde databases to a sql
server 2000
1) detach the database from the msde instance by using the sp_detach
command and attach it to the sql server 2000 using the sp_attach command
2) backup the msde database . copy the backup files to the new location and
then restore the database to the sql server 2000

This KB article also contains more details.
HOW TO: Move Databases Between Computers That Are Running SQL Server
(314546)

Girish sundaram

This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Move a MSDE to SQL 2000

Greg Low [MVP]
11/26/2004 11:03:35 AM

Hi Eduardo,

Keep in mind that if you have SQL Server logins (ie not just Windows
authentication in the same domain), you will likely have security ID issues
to deal with. If so, take a look at sp_change_users_login for more info.

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

[quoted text, click to view]

Re: Move a MSDE to SQL 2000

Eduardo Crespo
11/29/2004 3:18:12 PM

Thank's a lot for your help!!

"Greg Low [MVP]" <greglow@lowell.com.au> escribió en el mensaje
news:%232shCP10EHA.1152@TK2MSFTNGP14.phx.gbl...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.

home · blog · groups

Questions? Comments? Contact the dn