Our team has been using Microsoft Access 2010 as a frontend for an SQL Server 2014, and are dependent on the Upsizing Wizard in Access to migrate tables from Access to SQL.
For example, if there is an SQL database named papers, our team has an Access file named papers_temp.accdb. When we want to make changes to a given table (or create a new table) in the papers database, we do this locally in papers_temp.accdb before using the upsizing wizard to migrate the given table from Access to the SQL database, overwriting the table in SQL if it already exists.
From Office 2013 and Access 2013, the Upsizing Wizard is gone, and we are in need of an alternative. Is there a similar tool available for Access 2016, or do we have to adapt to something else entirely? So far open to suggestions.
SQL Server Migration Assistant for Access
I've been exploring this program for the last couple of days, after finding many recommendations for it on the web. It appears to be able to do the upsizing and migration that we need.
However, more often that not, when attempting to select (and load) a table, the program is stuck in a loading process that never seems to end (tried waiting for one hour), meaning I'm forced to close SSMA without saving my project. In general, the program does not seem very stable, and we'd prefer to find a solution that was more familiar to work with.
Perhaps I'm missing something?
