titorober23
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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