SQL Server migration projects don't necessarily include only SQL Server as a primary data source, but there are many other platforms where you may choose to upgrade to SQL Server. You can use SQL Server Migration Assistant (SSMA), which is available for several DMBS systems:
- SSMA for access
- SSMA for DB2
- SSMA for Oracle
- SSMA for SAP ASE
- SSMA for MySQL
SSMA is able to create a project for a number of target versions of SQL Server, where SQL Server 2017 is included with both platforms—Linux and Windows operating systems. The other targets available are:
- SQL Server 2008/2008 R2
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017 Windows/Linux
- Azure SQL database
- Azure SQL Data Warehouse
If you would like to use the tool for the migration, you need to have drivers for correct DBMS systems in place. For access migration, you...
