Provides a way of SQL INSERT statements from a SQL SELECT statement.
Editor: pcpmSqlGen
Automatically generate a set of SQL INSERT Statements from a SELECT statement.
Quickly Create test data from existing data.
Take a snapshot of certain data without needing a full database backup.
Save data away prior to testing to allow the data to be easily reset following testing.
Quickly generate the syntax for an INSERT statement without needing to lookup column names and data types.
Distribute the contents of lookup tables to remote databases without needing a network connection and where synchronisation would be inappropriate.
Awards
Useful For
Quickly creating test data from existing data.
Taking a snapshot of certain data without needing a full database backup.
Saving data away prior to testing to allow the data to be easily reset following testing.
Quickly generating the syntax for an INSERT statement without needing to lookup column names and data types.
Distributing the contents of lookup tables to remote databases without needing a network connection and where synchronisation would be inappropriate.
Key Benefits
Fast generation of INSERT statements.
Easy to use.
Connects to SQL Server, Microsoft Access and other databases for which there is an OLE DB provider. you can free download pcpmSqlGen 1.0 now.