[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

Access 2007 migration to sql server

Hi

I have a split database(front end/back end), i just upsized it sql server.
everything is working fine, but it seems to be slower, when it tries to open forms it takes a while to load the data, i thought it was going to be faster.
do i have to do anything to improve the performance?
do i have to recreate all the relationships in sql, are the relationships migrated directly?
I am doing a test and runing everything from  a windows 7 professional 32 bit workstation.

please elt me know

thanks
0
titorober23
Asked:
titorober23
  • 2
3 Solutions
 
radcaesarCommented:
There is an option whether you want the keys to be created when you upsize the DB. I had done it from Access 2003 to SQL Server and Its perfect on my case.

Slows down means, from which application you query the upsized 2008 DB?
0
 
Anthony PerkinsCommented:
>> but it seems to be slower, when it tries to open forms it takes a while to load the data, i thought it was going to be faster.<<
If all you did was to "upsize" it then it is not surprising and a very typical question here.

>>do i have to do anything to improve the performance?<<
You need to re-analyze and re-write your entire app to take advantage of SQL Server functionality.  If you cannot do that, than do not bother and continue to use MS Access until it is finally discontinued.

>>do i have to recreate all the relationships in sql, are the relationships migrated directly?<<
They have no bearing on performance, if anything it will make it worse.
0
 
titorober23Author Commented:
should i create every single table in sql and then import the data?
should i review the config of each table?

what is the best way, because even it is working it's taking to long to populate data in forms?
so how can i prove my team that sql offer better performance than access, when it is acting slower
0
 
Anthony PerkinsCommented:
The table structure is not the problem.  The problem lies in the way you are accessing it.  

>>so how can i prove my team that sql offer better performance than access, when it is acting slower <<
You can't.  As I stated before, if all you did was migrate the data and change the connection string, then it will be slower.  Period.  
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now