SQL Data Exporter is easy to use Microsoft SQL Server tables content-scripting software. It allows you to generate INSERT SQL statements representing table rows. For example you have table Table1:
| id |
value |
| 1 |
String1 |
| 2 |
String2 |
As a result SQL Data Exporter will generate SQL script like:
delete Table1
GO
SET IDENTITY_INSERT Table1 ON
GO
insert Table1 (id,Value) values(1,'String1')
GO
insert Table1 (id,Value) values(2,'String2')
GO
SET IDENTITY_INSERT Table1 OFF
GO
This is full functional version with AD screen. If you wish to remove it please purchase the software for $10 only.
Why do you need tables scripting?
Such functionality could be really helpful if you are replacing some strings in tables columns. You simply unload tables’ content into a file using SQL Data Exporter and then replace desired strings using your favorite text editor. You can unleash the whole power of contemporary text editors using regular expressions for example.
If you are developing distributed database-driven application that needs installation, you surely need tables populating with predefined values while installing. SQL Data Exporter will help you in this task. SQL Data Exporter appends tables’ content script to a script generated by standard Microsoft SQL Sever tools. Here you can find an article about
writing simple database installation for ASP .NET application using SQL Data Exporter.
If you need to transfer some records, it is possible to generate the script and delete unnecessary records manually. In the future versions we plan to extend SQL Data Exporter functionality to allow scripting exact records found using SQL statements. You can easily make a copy of existing table and much more.
Is it hard to use?
Of course not. SQL Data Exporter has Wizard interface that allows you to generate desired script in several steps. Each step gives you contextual help with detailed descriptions of windows elements. we will be happy to answer any questions or suggestions you might have on SQL Data Exporter or on extending its functionality.