Review: SqlDataScripter 2.0

SqlDataScripter 2.0
Phoenix, Arizona

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 savings here.

About the Author

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.


Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.

Upcoming Events