Go to Top

Access 2013 is here, but where's the SQL Server upsizing wizard?

Office 2013 has gone on sale and already I’ve seen posts online from people asking about the SQL Server Upsizing wizard not found in the tool.

It’s no longer available

The wizard was a causality in Access 2013 and frankly I say good riddance. I for one thought it was barely usable when it worked, since more often than not we were using a version of SQL Server that the wizard could not understand.

Use SQL Server Migration Assistant (SSMA) 

A much better tool, (and now your only choice with Access 2013), is to use SSMA to create your SQL Server database. We use it at our firm and we enjoy the many features it provides:

— Ability to change settings and customize the tool to our preferences

— Allow us to save the migration package and run it as many times as we wish. (We use it to upload new versions of data up the release of a SQL version, a post on this technique is coming soon)

— Works with all versions of SQL Server and Access

 Is upsizing your Access database more than you can handle? Let the pros do it for you! Call us at 773-809-5456 for a quote on upsizing your database today.

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

3 Responses to "Access 2013 is here, but where's the SQL Server upsizing wizard?"

  • zakraket
    February 26, 2015 - 9:50 pm Reply

    While SSMA works, it leaves the databases littered with junk: false constraints, extended properties on tables/fields. These will prevent migrating a SSMA Access>SQL database from SQL to Azure.

    Is there a way to use SSMA without creating these items when migrating to a local SQL-server?

  • Chris Hugo
    November 18, 2013 - 12:12 am Reply

    Hi Jaun,

    Thanks for a great blog! I’ve recently started developing in Access 2013 (did work many years ago on older versions). I have the SSMA that came with SQL 2012 Express. There doesn’t appear to be an option for importing the .accdb file type, only the .jet. Is there some trick to making that option appear?

    • Chris Hugo
      November 18, 2013 - 2:53 am Reply

      Nevermind. I figured it out. Kind of a bonehead mistake. I loaded the SSMA but then realized I was using the Import and Export Tool. When I actually started using the SSMA, it worked. I did have to load the Access 2013 runtime before it worked. There’s some great info out here and I appreciate what you are doing.

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Contact Us
  • This field is for validation purposes and should be left unchanged.