Storing of SQL commands When coding we use an offline database (or sandbox) that allows us to change whatever we like duirng development. As we make changes to the database we store the SQL commands that are used to make these changes. Getting tired of copying and pasting the commands back into the SQL manager once we took the changes live I decided to write a some code to read from an XML file and implement the changes. Structure of the XML file The strurcture we decided on was something that was general enough to allow for room to grow, so we came up with this: XML structure: <commands> <command type=" sqlcommandtype "> SQLCommandText </command> ... </commands> Where: sqlcommandtype : is the type of commnad: select, insert, update, alter , etc or disabled SQLCommandText : is the actual command Example of XML file Here is an example of the a file: <?xml version="1.0" encoding="utf-8"?...
Just some opinions and things I have committed to virtual prosperity just in case UGAF