|
DataBase Code Conversion Tool
(Switch between SQL and OleDb Managed Providers)
All you need to do is to paste your code into the top window. Then, depending on how you'd like it changed, choose the appropriate button (OleDb to SQL or SQL to OleDB).
Also - you can rest assured that no data is being saved on our end - it is merely changed and passed directly back to the output textbox
Disclaimer: Since there are some properties/methods, etc that do not have 1 for 1 crossovers between providers, some cleanup may still be necessary. This conversion tool is meant to convert the Major items which distinguish the SQL Managed Provider from the OleDb Managed Provider.
Also - Keep in mind - there is no way to know your connection string, so it wil also not change your database connection string. A generic connection string for the appropriate database will be provided at the end of the conversion code.
Input:
Result -- :
*Some items that may not have direct sibling classes across providers:
OleDbLiteral, OleDbSchemaGuid, OleDbPermission, OleDbPermissionAtribute.
Please let us know how this works for you :
Feedback is readily appreciated!
Changes:
v2 - case sensitivity no longer a problem (12/4/2002)
v3 - added generic connection string for use (12/14/2002)
|