Wednesday, October 9, 2013

How to convert SQL Server 2008 database to 2005/2000

Some time it is a big problem when you develop any application with higher compatibility and customer production environment has downward compatibility, it is very common in in version of SQL Server version.
As Microsoft don't support higher to lower version compatibility in SQL Server.

In our my example we are going to convert a SQL Server 2008 database to SQL Server 2005 version downward.

Open Microsoft SQL Server Management Studio and right click on your database.


After this select you required database and don't forget to check on option "Script all objects in the selected database"

In options select Script for Server Version to SQL Server 2005 or 2000. Here is one thing is notable if want your data also with the script then select Script Data option to true, but sometime your database is enough big to load in Management Studio so it is unable to open in IDE. In this situation you can skip  Script Data option and leave it false as default. I will explain how you can transfer data in this post

Now you can run the script on production environment. If database is big and your have no option to transfer data via SQL Server connection then you have to install a older version of SQL Server on your development machine and first make a copy of converted database to that and then you can backup the database and restore it on production machine.

Click Next you need to choose output option as you want to save a script file or in clipboard or to a new query window in SQL Management Studio. 

Click Finish

Author Qasim Sarfraz

No comments:

Post a Comment