pcpmSqlGen

pcpmSqlGenAutomatically 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.AwardsUseful ForQuickly 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 BenefitsFast generation of INSERT statements. Easy to use. Connects to SQL Server, Microsoft Access and other databases for which there is an OLE DB provider.