<div>
When generating the script on sql 2005 express select the option of 2000 compatible and then run it on sql 2000 server
</div>


When generating the script on sql 2005 express select the option of 2000 compatible and then run it on sql 2000 server

<div>
I can't find the 2000 compatible option on my copy of SQL Server Express. &nbsp;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. &nbsp;Where is the 2000 compatible option?
</div>


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?

<div>
<div class="content wysiwyg-content">
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 &nbsp;to a SQL Server 2000 database. <br />
<br />
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.<br />
<br />
What's the easiest way of doing this?
</div>
</div>


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?

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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.