LiveDataScript: Scripting data from a database into insert statements
We've partnered with a company called Live Software Solutions on a number of projects recently and they've just decide to release a great tool we've been using on a number of projects as a free download.
It allows you to generate a single script with insert statements from multiple sources and is useful for when you have data in one database that you want to write into another, for example you've got a developer database and you want to script out a subset of data that will be used on QA and production.
It's also great when you want to get data out of a table based on joins to another table because that's quite tricky to get setup any other way but with this you simply write your select statement and then script the selection out.
Check it out here: http://www.lss.co.uk/Products/LiveDataScript/
Christian Bolton - MCA: Database, MCM: SQL Server 2008
http://coeo.com - The SQL Server Experts