by Adhadi Mohd (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (4 Votes)
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.
Code Returns
Returned schema for 100+ tables in 17 seconds.
Returned 30000+ insert statement (with text datatype) in 100 seconds.
(Medium sized development server)
Download Automated SQL Mass Insert Statement / Database Schema to XML Generator (25 KB)
No comments have been posted about Automated SQL Mass Insert Statement / Database Schema to XML Generator. Why not be the first to post a comment about Automated SQL Mass Insert Statement / Database Schema to XML Generator.