Brandon McCulligh's Portfolio
Proof Of Concepts
Cross DB Compatibility Validator
Lines of Code:
Start -> Programs -> Brandon McCulligh
Windows XP and Higher
This tool was created because of problems I ran into migrating a database. A lot of the table names I had used were keywords in the new database software so I decided to write a tool that could validate a schema so that it does not contain any keywords for any database software.
Going forward any database I design now, before finalizing the schema I will validate it through this tool, if the tool says there are no conflicts than the schema will be final and ready for data.
Taking the 15 seconds to run your schema through this validator literally can save you hours upon hours of work should you need to migrate a database.
How does the tool work? The tool compares your Column and Table names against the DB Software .DAT files.
Supported Database Software;
- SQL Server
Cross DB Compatibility Validator Installer.zip
Mode 1(Pasting your schema into the window)
1) Paste your databases SQL into the window
2) Hit "Validate Schema"
3) View the status and errors if any
Mode 2(Pointing to a schema file on the file system)
1) Select the "File" radion button
2) Load the SQL file for your schema
3) Hit "Validate Schema"
4) View the status and errors if any
Powered by: Great White North Productions© Technologies