Access connectivity components for SSMA

We often receive questions about what is really needed to work with Access databases in SQL Server Migration Assistants (SSMA) for Access, so I thought I’ll do a quick run through what is actually required. The typical error message that you will get in SSMA, if required components are missing will look like this: “Retrieving…

0

SQL Server Migration Assistant: How to assess and migrate data from non Microsoft data platforms to SQL Server

Follow these step by step instructions to migrate schema and data from non Microsoft data platforms to SQL Server. This post illustrates the migration of an Oracle HR schema to SQL Server vNext CTP1 on Linux. Assess the source database and discover conversion rate and effort to resolve issues Click on the “File” menu and…

1

Released: SQL Server Migration Assistant (SSMA) v7.1

Overview SQL Server Migration Assistant (SSMA)  for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2 and Access lets users convert database schema to Microsoft SQL Server schema, upload the schema, and migrate data to the target SQL Server (see below for supported versions). What is new? SQL vNext on Windows and Linux CTP1 is…

2