MS Access to SQL Server Express Migration ASP SQL queries language
Posted on 2007-04-01
For a few years now I have been running an asp applicaiton with a MS Access Database. Now is the time to move over to MS SQL Server 2005 Express.
Originally I used paramaterized queries in Access but a year ago i though it would aide my inevitable DB migration more painless by coding the SQL in asp instead, leaving just the table structures and data intact in Access. I now realise I may have been better off leaving alone.
My problem is how do I easliy migrate the data and queries to the new dbms (sql server express). The MS management studio seems to have translated the tables (although my Access database used uk date format #31/12/2006# and clearly this has changed although Im not sure how) but the sql which queires the MS access db needs to be 'translated' (including some complex and lenghthy sql) to work with the new dbms.
I would be really grateful for some advice on this experts.