SQL Server 2008 finally we can script data

I was at the UK launch of SQL Server, but a lot of that event seemed to focus on some very niche features, new location type data, the usual better performance stats and better reporting facilities.

While these are great, I dispair at the loss of the open table, now we open top 200 for editing. I understand that the open table was not efficient but it was handy when something has gone wrong at the 11th hour; so why not just give both options? you can do the top 200 on a production machine, but use the open table where you need to check out all the data.

I have been jeolous of mySQL for a while now, they had script objects and data; this was something I used to use in the 80’s with Artemis (awsome project management software) so disapointed that it didn’t exist in SQLServer. But now in SQL Server 2008 it’s there!!!! on the database name in the tree control select tasks/generate scripts. The wizzard take you through what you want select data in the wizzard and BINGO !  You get the structure of the database and the data, in a .sql file (text file) this is usually a fraction of the size of a database backup and as it’s in text format is really difficult to corrupt or have other problems.

Life is indeed great again!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.