Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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


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.