We help IT Professionals succeed at work.

Access 2007 migration to sql server

Medium Priority
284 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

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
CERTIFIED EXPERT
Top Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.