Solved

Export SQL Server Tables from SQL Server 2005 Express to SQL Server 2000

Posted on 2007-04-04
4
279 Views
Last Modified: 2010-03-19
I have created a database on Microsoft SQL Server Express and I need to export a number of tables (but not all tables) complete with the index information  to a SQL Server 2000 database.

The problem is that the CREATE scripts generated by SQL Server Express are not compatible with SQL2000 so that, when I try to run the scripts on the SQL 2000 server, they fail the syntax check.

What's the easiest way of doing this?
0
Comment
Question by:ccravenbartle
  • 2
4 Comments
 
LVL 28

Expert Comment

by:imran_fast
ID: 18849866
When generating the script on sql 2005 express select the option of 2000 compatible and then run it on sql 2000 server
0
 

Author Comment

by:ccravenbartle
ID: 18850020
I can't find the 2000 compatible option on my copy of SQL Server Express.  I am generating the scripts by right clicking on the table to be exported, selecting the Script Table as CREATE TO, selecting the File option and then entering the name of the .sql file.  Where is the 2000 compatible option?
0
 
LVL 28

Accepted Solution

by:
imran_fast earned 250 total points
ID: 18850265
Because you have express edition, its there in the other editions like standard and developer editions.

Try using DTS of sql 2000 to import the objects from sql 2005 express to sql 2000.
0
 
LVL 7

Assisted Solution

by:assyst
assyst earned 250 total points
ID: 18850627
compatability level is available with sql2005 express edition
..for changing the compatabiliity level ..right click the database, select properties...goto options and there u can see the compatability level ..

or else use [sp_dbcmptlevel] to change the compatability level to 2000
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now