March 8, 2008 at 8:07 am
we are currently working on upgrading a massive project, which will take about 2 years to complete, to upgrade a vb6/access2000 project to vb.net and sql2005 or greater(by the time its done).
my question is does it make sense in the mean time to take my access dbs and remove the direct access dbs and make them links to a sql server?
my thinking is then I can get greater database sizes, more scalability with my program without changing all db connections, logic, sql statements, and most DAO and ADO mix of code to accomodate all this?
Would just switching the access dbs to sql links be worth the switch over?
we currently have users that are about 5 users in one database at a time.
what are your thoughts?
Any help would be appreciated.
March 8, 2008 at 8:38 am
Since an Access DB was not really designed to be concurrent user you may gain some benefit by upsizing to SQL Server. You can test it first. The other benefit is that the DB side is done and you can start writing your .NET code at any point against a copy of the SQL Server DB. The downside is that by just upsizing the DB you may not be taking advantage of many of the features in SQL Server, like SP's, triggers, etc... It will also make it easier to do the data transfer if you do redesign of the DB.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply