Click here to Skip to main content
Click here to Skip to main content

Database Script Generator

, 9 Oct 2006
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

Introduction

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

License

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

Share

About the Author

Ajey Dudhe

India India
No Biography provided

Comments and Discussions

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