Scripting SQL 2008 Objects and Data with Backward Compatibility
Wednesday, September 23rd, 2009I had a chance to work with a 3rd-Party tool that dumps data into SQL Server. An issue came up because it only works with SQL Server 2008. In order to support a customer case, I had to have that data in SQL Server 2005 (it doesn’t happen often to take you too much time to migrate data from a newer version of SQL Server to the older one).
Luckily, SQL Server 2008 has a great feature. The feature is Generating Scripts. It makes it possibile for users to generate script for creation of any scope of database objects very easily.
The feature is accessed by right clicking the database then choosing “Tasks >> Generate Scripts”. The wizard is very intuitive and enables the creation of script compatible even with SQL Server 2000 – which generates the whole database, with all tables, data in tables, indexes, triggers, stored procedures, collations, and anything else that comes to mind.
In my case, I was not able to do this through Access, Excel or any other way. Without this feature I, the case would be stuck.