Want to upgrade from Access to SQL Server ?

[vikramonline]

I am using MS-Access with ASP right now and I wanna upgrade to SQL Server.I wanna know that am I supposed to make huge changes in the code, or are the changes minor ??

 

[Tarwn]

The changes should be minor. If the table layout is going to be the same then you may even manage to get away with only having to change your connection string. Just make sure you run through each of tyhe pages and try the sql strings that are in place in case any of them need a minor alteration to work with SQL Server. I think most, if not all, of the functions useable in an Access query qill be available from SQL Server also, but I wouldn't be able to guarantee that.

-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/

 

[vikramonline]

Thanx Tarwn,

I had the same thought..just wanted to confirm.