Moving Data from SQL Server 2000 to SQL Server 2005 - Parking Data in SQL 2005 Server

(Page 3 of 4 )

Step 1: You must paste the copies of northwind.mdf and northwnd.ldf files to a suitable location. SQL Server 2005 database files are found at: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\. Hence you should paste the Northwind data files to this folder as shown here:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\

northwnd.mdf

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\

northwnd.ldf

Step 2: Make sure the SQL Server 2005 is running. Right click the Databases node (currently there is no Northwind database) and click on Attach...as shown in the figure.  

Step 3: The Attach Databases window pops-up as shown. Click on the button Add....

Step 4: This opens up the Locate Database Files - HODENTEK window. Expand the nodes as required and locate the *.mdf files. This window does not show the *ldf files.

Step 5: Highlight northwnd.mdf and Click OK.

Next: Parking Data in SQL 2005 Server, continued >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Moving Data from SQL Server 2000 to SQL Server 2005

· If you started with SQL Server 6.5 like I did, you will find the SQL 2005 Server...    · You may also need to adjust the compatibility setting (properties>Options) to SQL2k5...    · Thank you for the kind comment. Data which has is moved to SQL 2005 has most of the...    · I'm a noob to sql 2005 and this was just what i needed to know and it worked...    · hi JayaramI have an expired SQL Server 2000 (SP4) Installation, with a a couple...    · Question: How can I upgrade from the expired evaluation version of SQL Server 2000...    · Ben:After you install the Express edition follow the same procedure as in thsi...    · How i will migrate the registered users from SQL2000 to another server with SQL2005...    · Hi Jay,Thanks for your tutorial on the migration process. It was indeed...    · You can use the stored procedure sp_help_revlogin which does an admiral job at...    · Hi, in your comment you say that you start with SQL 6.5 ...Ok, I'm new in SQL...    · Can I have the same tutorial    · Is there any reason you could not migrate a database from 2000 EE to 2005 SE? And...    · Hi Jay,I have a SQL 2000 server and want to move to SQL 2005. But the condition is...    · Hi Everyone,I too am rather new to SQL as well. We are migrating everything from...   >>> Post your comment now!