Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zirocool
Starting Member
3 Posts |
 Posted - 2008-09-11 : 03:56:48
|
| Hello all,this is my first post here in the forum so forgive me if this thread is not in the correct category.I have a Web-Application that works with Access as the DB and developed in ASP.After sometime, I took the job to convert the Access DB into a SQL server 2005 DB.I used the Microsoft's SSMA which was almost perfect regarding to the tables convertion.The problem was that all the queries are built-in on the ASP pages.(There is no stored queries / sp in the DB).I used your "Convert Microsoft Access (JET SQL) to SQL Server (T-SQL) Cheatsheet" article as a guideline and started converting some of the queries on the ASP files.So far, everything sounds good.The problem is that I have little more than 500 ASP files and converting all the queries can take ages!so I had an idea - Create a function that will take the complete JET-SQL query and dynamically (on runtime) convert it to a normal T-SQL query and then pass the new SQL query to the RecordSet.Before I'm starting to be a RegEx junkey for the next (who knows) weeks :) I wanted to know if there is another solution that you're aware of.Thank you |
|
|
|
|
|
Not an ordinary JET-SQL to T-SQL question