Wednesday, May 20, 2009

New Features in SQL Server 2008...

There are Several New features in SQL Server 2008. In one of the instance I had upgraded 2005 SQL Database to SQL 2008. Then later i found out that i had to recreate the database in 2005 again. At this point i did not have SQL 2005 database backup, I was stuck for a while. Then on exploring the various tasks i found the following task which helped do my job. In the SSMS 2008, right click on the database, then click on Tasks, then click on Generate Scripts.

This will launch the Script Wizard, Choose Next, In the next screen choose the database, then choose the Choose Script Options. In this there is a option for Script for SQL Server Version, in this choose SQL Server 2005. This will generate the scripts compatible with SQL Server 2005. This would enable to create all the objects required for a SQL Server 2005 database.

There is another neat feature in this screen which the Script Data option, in case the sql server 2005 database needs to populated with Data, this can be set to true. This would enable to load a sql server 2005 database. These features came in handy when i had to go back to a SQL Server 2005 database.

No comments:

Post a Comment