Upgrading from MSDE to SQL 7.0

[jamminjaymeyer]

I need to update from MSDE to SQL 7.0 because of size problems. Has anyone ever upgraded like this? How easy is it and have you had any problems. Is it easy to keep your data?

Thanks,
JamminJayMeyer

 

[fluteplr]

piece of cake. Do a backup on the database on MSDE and restore it to SQL Server. You will need to set up your security logins again however.

 

[jamminjaymeyer]

Is there a command to do this backup and restore. I don't seem to have any tools to do much in MSDE?

Thanks for the responce.

 

[tlbroadbent]

Create a T-SQL script to backup your MSDE database(s).

http://support.microsoft.com/support/kb/articles/Q241/3/97.ASP

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[jamminjaymeyer]

After you back up can you just install SQL Server 7 right over MSDE?