Database Script Generator

• Download source files - 72 Kb

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.<o:p>

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.<o:p>

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 :-)<o:p>

Also, currently this utility only generates scripts\XML for data changes and not the schema changes.<o:p>

Steps to use:<o:p>

1. Launch the application <o:p>
2. Specify the old and new databases <o:p>
3. Select 'Scripting Options' i.e. whether you want to generate SQL scripts and\or XML file <o:p>
4. Select the changes you need to consider i.e. rows inserted\deleted\updated <o:p>
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) <o:p>
6. The output files will be generated in the same folder as DatabaseScriptGenerator.exe<o:p>