i want to upgrade my db from access to sql server.

will this affect my asp pages. basically i am aware that i will have to 

change my connection string from access to sql but what worries me is taht 

i have deisgned queries in my access database so will i have to redesign 

them in sql server??



plz let me knwo

thanks in advance for your reponse

Hi!



Microsoft have an upsizing tool the will do the conversion from Access to

SQL Server. The SQL is pretty much the same except for some delimiters for

dates (Access uses # and I think SQL Server uses ') It shouldn´t be much

work after the conversion, but maybe someone else has had more problems.



Hakan



-----Original Message-----

From: Taher Moiyed [mailto:taherm@f...]

Sent: den 15 juni 2001 14:09

To: ASP Databases

Subject: [asp_databases] will upgrading my db from access to sql server

affect my asp pages





i want to upgrade my db from access to sql server.

will this affect my asp pages. basically i am aware that i will have to

change my connection string from access to sql but what worries me is taht

i have deisgned queries in my access database so will i have to redesign

them in sql server??



plz let me knwo

thanks in advance for your reponse