I had tried to attach database in SQL Server 2008 which I was created it in SQL Server 2005, but the error happened when I added the .mdf file followed by error message
Then I imported the database from SQL Server 2005 to SQL Server 2008 through SQL Server 2008 that it works.
To Convert From SQL Server 2005 to SQL Server 2008
Following next steps:
1. Start >> all programs >>Microsoft SQL Server 2008 >> import and export data(64-bit)
2. SQL Server Import and Export Wizard appears
Click next.
3. Choose a data source
•Data source: Select Microsoft OLEDB Provider for SQL Server.
•Server Name: write the name of source server.
•Authentication: choose Use SQL Server authentication, and write user name and password.
•Database: Select the database name.
Click next.
4.choose a destination
•Data source: Select SQL Server Native client 10.0.
•Server Name: write the name of destination server.
•Authentication: choose Use SQL Server authentication, and write user name and password.
•Database: Select the database name
0r if you want to create a new database click on new.
Write the name of new database >>ok
Click next.
5.specify table or query
Click next.
6.select source tables and views
Click next.
7. Save and run package
Select Run immediately >>click next.
8.to complete this wizard >>click finish
9.finally click on close
1 Oct 2009
Convert From SQL Server 2005 to SQL Server 2008
Posted by
Hayfa
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment