Upsizing from Access to SQL Server (query strings)

Originally posted by : Dave Stewart (david@dannasoftware.com)I have two ASP apps currently running with Access data sources but I need to upsize the data to SQL server.Is there a script or easy way to convert my access sql strings for ADO to the proper syntax for SQL Server or do I have to just manually edit each of the hundreds of strings?Thanks in advance.

Originally posted by : THeDude (TheDude@bananateam.nl)hi,The SQL syntax for sql server is the same is in access, the only thing you should change is the connection string. There's not really a script to modify this, unless, every connection string is build in the same way. If so, write a script, that searches the text for the specified type. You can also try the find option in NotePad. If you have your connectionstring build in the code for every individual page, maybe it's more easy'er to put the connection string in include files in the future. regards the dude------------Dave Stewart at 11/28/2001 1:11:07 PMI have two ASP apps currently running with Access data sources but I need to upsize the data to SQL server.Is there a script or easy way to convert my access sql strings for ADO to the proper syntax for SQL Server or do I have to just manually edit each of the hundreds of strings?Thanks in advance.