Converting a MySQL Injection Script for Use in Microsoft SQL Server

Finally, there will also be numerous occurrences of apostrophes throughout the text fields of the data, and the apostrophe character is used to encapsulate strings in the script. In MySQL, the way to escape an apostrophe so that the script knows it is part of the text and not the end of the string, is to use a backslash followed by the apostrophe ("\'"). In a MSSQL Server script, the proper way to escape an apostrophe is to use a double apostrophe ("''"). So, one more search and replace is called for -- this time, replace all instances of [\'] with [''] (double apostrophe, NOT an actual quotation mark).

Once these steps are all complete, you are ready to run the script! There shouldn't be any other syntax changes you'll have to make, but don't worry if there are because when you execute the injection script it will tell you if there are any errors. If everything was corrected properly and there are no errors, you should get a series of "1 row(s) affected" responses -- one for each INSERT statement in the script. If you want to verify that the proper number of records are in the database table, you can execute a "select count(*) from tablename" statement to count the rows of the table -- it should match the number of lines in the injection script, give or take a few for blank lines, etc.

That's it! Your options are now increased tremendously, because now you can use either MySQL or MSSQL injection scripts to import acquired databases into your database system. If you use MySQL as your dbms, you can do this process in reverse to convert a MSSQL injection script into a MySQL one. Either way, you now can import data using an injection script from either of the two most popular database management systems in the world. Now, where to obtain such databases or injection scripts is another question entirely, and beyond the scope of this article. Suffice it to say that there are numerous sources on the internet where you can purchase or acquire databases -- a good one is www.WebContents.org. I think you will find that not only is it much easier to acquire content databases for your users than it is to build them from scratch, but it also is an easy way to add a lot of new, fresh content for your users with a minimal amount of time and effort. Using this method, you can get databases of articles, jokes, quotes, recipes, etc, and put them right on your website or any other database-integrated application, with very little work. Good luck!