Marshall’s Weblog

Embiggen Your Mind

Marshall’s Weblog header image 2
← Around the Web with Java, now with more Java The Weekend Report →

SQL Scripter

January 18th, 2005 · 2 Comments

SQL Scripter is a program which will connect to a SQL 7.0 or 2000 server and generate a script of a table or multiple tables which will allow you to copy data over two disconnected SQL servers.

Tags: Programming · Random Linkage

2 responses so far ↓

  • 1 Scott Wisniewski // Jan 18, 2005 at 1:10 pm

    You should check out SQL Compare from red gate software. In addition to being able to script databases, it can do a diff between the structures of two databases and can be instructed to generate a script to make one of the database look like the other one. Its very useful for synronzing development and test / production servers.
    http://www.redgate.com/SQL_Compare.htm

  • 2 Marshall // Jan 18, 2005 at 1:14 pm

    Thanks. I’ll look into it. SQL Scripter is simple and powerful enough that if I need to import some data for someone, I can just click the table that I want to export and it will generate a sql file. It can generate exists checks and do updates on existing records.