Opening 2005 Data in SQL2000

[jwillard]

Does anyone know of a way this can be done? We have a remote server with 2005 but I only have 2000 locally and I want to work on the data locally......

Boycott Sony

 

[mrdenny]

You will need to use DTS or SSIS to migrate the objects from the SQL 2005 server to the SQL 2000 server. You can't backup and restore from SQL 2005 to SQL 2000.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[triggerhappy]

you can connect to the server through Query Analyzer...and perform normal DDL/DML operations. You cannot connect 2000 Enterprise Mgr.

Also, make sure the SQL Server 2005 has the remote connections option enabled. By default this option comes disabled in SQL 2005.

Hope this is helpful!

--

TriggerHappy

 

[jwillard]

Thanks for the replies. I will try over the next couple of days....

Boycott Sony