Review: SqlDataScripter 2.0
Some utilities exist with a very clear focus. SqlDataScripter is one of
these. As you may know, SQL Server Enterprise Manager will generate DDL
scripts for you, so you can move the structure of a table from one
server to another. But it wont' do anything to let you script data
movements. SqlDataScriper steps into that gap.
The utility is easy to use. You pick a database and connect to it, then
decide which data you'd like to script. Press a button, and you get SQL
INSERT statements that you can save or copy off to run. It's that easy.
A few options let you choose things like date and numeric format. You
can also include DDL scripting, in case the target database doesn't have
the appropriate table in it.
Sure, you can do this by hand with DTS, among other ways. But if you're
needing to move data around a lot, you might well find $20 worth of time
Mike Gunderloy has been developing software for a quarter-century now, and writing about it for nearly as long. He walked away from a .NET development career in 2006 and has been a happy Rails user ever since. Mike blogs at A Fresh Cup.