Home Forums SQL Server 7,2000 General Is it possible to move database from sql server 2005 to server 2000 ..?? RE: Is it possible to move database from sql server 2005 to server 2000 ..??

  • Hello

    What I have used is the Microsoft SQL Server Database Publishing Wizard , you can download it from the MSwebsite, it will generate a file with the T-SQL scripts for the objects in your database.

    You can also include the data!

    Then you can create the database in SQL 2000 and run the file in Query Analyzer and that's all.

    However you need to be careful because if you're using some SQL 2005 features in your code (like Try-catch error in Stored Procedures) that won't work for SQL 2000

    Hope this will be useful for you!