Rx_
01-19-2012, 02:45 PM
Planning to move a MS Access 2010 back-end to SQL Server 2010 and using Linked Tables from the front-end.
What is best? The Access Upsizing tool?
Or using the SQL Server Management Studio (SSMS) import (from Access) tool?
At the bottom of this site (or Find Upsizing) see upsizing:
http://www.functionx.com/access/Lesson04.htm
Microsoft community forum claims SSMS is best. But, often a SQL guru doesn't know all that much about Access.
I am a medium SQL user, installed, set up, assigned rights, created the database, and sucessfully linked a table to Access via ODBC. Can write stored procedures, create views and so on.
Many articles are Access 2003 or 2007. Just wondering about Access 2008? If anyone has experience or comments on the best for the least amount of touchup work after the data move. It is a fairly big DB (40 M) with many queries, tables, and a rich user front-end experience.
What is best? The Access Upsizing tool?
Or using the SQL Server Management Studio (SSMS) import (from Access) tool?
At the bottom of this site (or Find Upsizing) see upsizing:
http://www.functionx.com/access/Lesson04.htm
Microsoft community forum claims SSMS is best. But, often a SQL guru doesn't know all that much about Access.
I am a medium SQL user, installed, set up, assigned rights, created the database, and sucessfully linked a table to Access via ODBC. Can write stored procedures, create views and so on.
Many articles are Access 2003 or 2007. Just wondering about Access 2008? If anyone has experience or comments on the best for the least amount of touchup work after the data move. It is a fairly big DB (40 M) with many queries, tables, and a rich user front-end experience.