• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Automated SQL Mass Insert Statement / Database Schema to XML Generator

Automated SQL Mass Insert Statement / Database Schema to XML Generator

The reason of doing is because I need to install my application together with database (schema & lookup data) at the client site.
Of course we can do this using different approach like BACKUP/RESTORE, or MS Access upsizing. In my case, I need to script all the schema and the lookup data to have a better control to the setup file.
Download VB6x LIbrary before using this program.
https://www.geocities.com/adhadi/HadiLIb.zip

Assumes
SQL 2000 or MSDE2000 was installed.

Returns
Returned schema for 100+ tables in 17 seconds. Returned 30000+ insert statement (with text datatype) in 100 seconds. (Medium sized development server)

Rate Automated SQL Mass Insert Statement / Database Schema to XML Generator

• 1
• 2
• 3
• 4
• 5

(5(5 Vote))

Download Automated SQL Mass Insert Statement / Database Schema to XML Generator