Click here to Skip to main content
11,701,855 members (69,328 online)
Click here to Skip to main content

Database Script Generator

, 9 Oct 2006 27.1K 891 19
Rate this:
Please Sign up or sign in to vote.
This utility can be used to compare two MS Access databases for changes in the data. You have the option of generating the SQL scripts and\or a summary XML
<!-- Article Starts - DO NOT ADD HTML/BODY START TAGS-->

Sample Image - DatabaseScripting.jpg


I created this utility for quickly generating the SQL scripts for the changes made to the database. Afterwards, I also added the option to generate the XML which can then be consumed by any application.

Mostly we use Access databases for storing the configuration or other information. I came across such situation where I had to change the database. Then to keep track of the changes we use the SQL scripts. To speed up the process I created this utility.

Since, I had not used C# before; I developed this utility using C#. So, you may find many issues with the code. But at the end it serves the purpose Smile | :)

Also, currently this utility only generates scripts\XML for data changes and not the schema changes.

Steps to use:

  1. Launch the application
  2. Specify the old and new databases
  3. Select 'Scripting Options' i.e. whether you want to generate SQL scripts and\or XML file
  4. Select the changes you need to consider i.e. rows inserted\deleted\updated
  5. In case some tables don't have primary keys you can specify the fields that will uniquely identify the rows using PrimaryKeys.xml. This must be in the same folder as the DatabaseScriptGenerator.exe. (The template is included in the src)
  6. The output files will be generated in the same folder as DatabaseScriptGenerator.exe


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author

Ajey Dudhe
India India
No Biography provided

You may also be interested in...

Comments and Discussions

-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.150819.1 | Last Updated 10 Oct 2006
Article Copyright 2006 by Ajey Dudhe
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid