Attaching a SQL Server 2005 database to SQL Server 2000
Home > IT Answers > SQL Server > Attaching a SQL Server 2005 database to SQL S...
SQL Server Ask the Experts
2445 pts.
0
Q:
Attaching a SQL Server 2005 database to SQL Server 2000
SQL Server 2005, SQL Server 2000, SQL Server databases, SQL Server 2005 Database
How can i attach a database created in SQL Server 2005 to SQL Server 2000?
ASKED: Mar 16 2009  5:25 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You can't attach a SQL Server 2005 database to a SQL 2000 server. You will need to script out the tables, procedures, etc adn then create them in the SQL 2000 server, then use SSIS or DTS to copy the data from the SQL 2005 server to the SQL 2000 server.
Last Answered: Mar 16 2009  7:15 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0