Thursday, March 8, 2012

Convert sql server 2000 database to sql express 2005

Hi;

I have a database in sql server 2000 and i want to convert it to sql express 2005, so please tell me how I can do this. Thanks

Adnan

I havent worked with 2005 Express but couldnt you back up the 2000 copy and restore in 2005?

|||

Hi adnan152,

The first question I want to know is that do you have SQL Management Studio Express installed on your machine? Well, if not you can download it by clicking this link:http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

And after you have installed management studio express, you can refer to the steps listed below(NOTE HERE that the following article is for SQL Server 2005, not express version, so maybe you cannot follow it 100% exactly. But since they are almost the same, so,, just FYI. I strongly suggest you taking it as a reference )

Moving Data from SQL Server 2000 to SQL Server 2005
(In order to detach a database, expand theServer node in SQL 2000 Server to reveal all the databases. Right click on the database you want to detach, in this case Northwind, and choose All Tasks. From drop-down menu click on Detach Database, as shown in Figure 1 below. Once you detach a database, that node disappears, but the related *.mdf and *.ndf remain where they are.

The Detach Database window ..........

More detailed informatin, please take a look at:

http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/1/

Also I want to verify if you also want to make the transformed database existing in App_Data folder. Just like aspnetdb.mdf. If you do need it, tell us, we will further help you. Thanks.

--

don't forget to mark as answer if you find our post helps you

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

|||

Yes, i have management studio, and it worked.

Thank you.

Adnan

No comments:

Post a Comment