Access to SQL Server conversion in ASP

[AlaskanDad]

I currently have several ASP pages that interact with an Access database. I know that this is a "toothpicks and duct tape" solution and I'll eventually have to move to SQL Server as my volumes increase.

My connection string to the database is a DSN-less Jet-OLE connection and my recordsets are all ADO's.

What do I need to do to upgrade? Will any of the non-connection ASP code have to be changed?

Luckily, I have my connection string in one global file so changing it will only be in one place.

Thanks in advance.

 

[Dynapen]

You shouldn't need to change much. But that depends on how your SQL statements are written on your page. There are some SQL syntax differences between Access and SQL. But for the most part, all that you should have to change is the connection string.

Best way to check is to do a response.write on some of the SQL statement that you are using to pull records from the database. Then copy and paste them from the page and try them against SQL Server. This will tell you if you have the right syntax for use with SQL server.

 

[AlaskanDad]

I've got nothing but select statements used for displaying info, updating info, adding new info, or deleting info.

I think they're pretty vanilla.

How does the movement of tables and queries from Access to SQL Server go? Is that a no-brainer also?