Best Front End

Hello,

I am new to SQL Server. I currently have an Access 2007 database and next year my client would like to migrate to SQL Server. Which Front End is the best...Access, VB.net or some other platform altogether?

Thanks,

M. Wilson

This is not an SSIS question. Moving to the "Getting started with SQL Server" forum.|||

There is no right answer to that as it really is more subjective and based on whatever skill sets are available to the business. Pretty much any front end will work fine if it is coded correctly.

On the other hand, many DBAs would say no front end is the best front end

-Sue

|||

As Sue already mentioned, this is a tough question and should be based on the environment and the business case. There is not only the decision which front end technique should be used, also which architecture should be used (tier based) / thin client / thick client, security, etc. Some decision might eliminate the usage of certain clients....

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Deployment issues and costs also play a role in determining the best development tools. If you have heterogenous clients (a mixture of windows, linux, and mac clients) perhaps a web-based front end is best. Do the clients aready have MS Access? If not perhaps a .NET application is best.

As Sue and Jens indicated, what is best for your environment really depends on your environment.

HTH...

Joe