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!

Share this:
Share this page via Email Share this page via Stumble Upon Share this page via Digg this Share this page via Facebook Share this page via Twitter
Share this Post:
Digg Google Bookmarks reddit Mixx StumbleUpon Technorati Yahoo! Buzz DesignFloat Delicious BlinkList Furl

No Responses to “SQL Server 2008 finally we can script data”

Leave a Reply:

Name (required):
Mail (will not be published) (required):
Comment (required):
XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


Stay in contact!

Email Dave Riley
Dave Riley's Linkedin Profile
Dave Riley's Facebook Profile
Dave Riley's Twitter Profile
Dave Riley's Plaxo Profile