SQL Server 2008 finally we can script data
Dave Riley | July 3, 2009I 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!
- Comments
- No Comments »
- Categories
- Coding, useful
- Tags
- cool, db, development, Microsoft, SQL, SQLServer
Comments rss
Trackback
Afterwards we had lunch which was a Chinese banquet - very nice i especially liked the noodles. Not sure why I didn’t take photos of that, maybe just focusing on the food 
If you come in summer you can interact with the live wasps (whatever that means) That sounds like a different experience altogether. We did get a discount only 500yen instead of the 1000yen it would be in Summer.
