Access to SQL Server 1

[nissan240zx]

Hello All,
In reality how much of an effort it is to convert applications built using VB/Access technology to VB/SQL Server.

What all things needs to be taken care of during conversion.
Is it too complex to do the conversion itself.

Please advice.

A good programmer is someone who looks both ways before crossing a one-way street. - Doug Linder

 

[mrdenny]

The amount of effort will depend on how complex the Access database is.

If it's a fairly straight forward database and all the database code that VB is executing the SQL complaint then it should be fairly easy.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[wwwSQLOBSERVERcom]

...and also how old your Access db is. We have one that's still on DAO!

http://www.SQLobSERVER.com

the Microsoft BI/DW community