Sql Script Writer

Generate SQL scripts to insert table data.
Download

Sql Script Writer Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Demo
  • Publisher Name:
  • The Professional Developer
  • File Size:
  • 533 KB

Sql Script Writer Tags


Sql Script Writer Description

Have you ever encountered a time with you needed to script table data when you deploy a database? Visual Studio allows you to script tables schema and compare table data, but not create a script that will actually insert data into tables when you deploy your database. TPD Sql Script Writer is a small utiltiy that will help you create scripts that allow you to deploy table data with simple Insert statements. These statements are wrapped in transactions so if something were to fail it would rollback. TPD Sql Script Writer is also intelligent enough to disable foreign keys and table constraints before inserting data, then re-enabling foreign keys and table constraints when finished. TPD Sql Script Writer is also a good way to backup your database. Script all tables to a .SQL file and store that file off in a safe location for disaster recovery plans. Main features: Create database default table data scripts. Creates INSERT statements for each row in each table selected. Wraps INSERT statements in TRANSACTIONS. Disables FOREIGN KEYs and PRIMARY KEYs before inserting data, then re-enables FOREIGN KEYs and PRIMARY KEYs after inserting data. Select only the tables you want to script. Ability to script each table to their own .SQL file. Ability to delete data in destination table before inserting new data. Supports MS SQL Server 2000, 2005, 2008, 2008R2. All data types supported. A good way to backup the data in your database or disaster recovery plans. Ability to handle single quotes.


Sql Script Writer Related Software