Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I know I'm going the wrong way but is there a way to move a database from a SQLEXPRESS 2008 server to an MSSQLServer version 2000?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

In SQL Server Management Studio on your SQL 2008 instance, right-click on the database whose data you want to move and choose Export Data... from the All Tasks submenu. There are options to connect to many different data destinations. For SQL 2000 your best bet is to connect to a Microsoft OLE Db for SQL Server destination and then plug your SQL 2000 server information in.

Do note, though, that SQL 2008 includes several new data types that are not available in previous versions of SQL Server. If any of your tables use one of those data types the import will fail without doing a conversion.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.