I originally posted
http://forums.microsoft.com/msdn/ShowPost.aspx?postid=900493&SiteID=1
How would I move a db in MSDE 2000 to SQL server 2003. I want to
include the db structure and data.
The MSDE and SQL Server system use the same file structure to store the information, the only difference is the engine. To move the MSDE Database to a full server install is as easy as backing up the database and restoreing it on the server install. This will work when transfering from MSDE 2000 to SQL Server 2005 (All Editions).
Remember if you need some management tools you can get the SQL Management Studio for SQL Server Express and connect to the database to assist in performing the tasks, or if you have the full SQL Server 2005 Install you can also use the Management SStudio that was installed with that.
The Express Management tools can be downloaded for free from the Microsoft Downloads Site.
|||A lot of options: backup/restore, attach/detach or ALTER DATABASE with MOVE option
No comments:
Post a Comment