573 questions with SQL Server Migration Assistant tags

Sort by: Updated
1 answer

What is the best approach to perform inplace upgrade first . is it OS or SQL ?

Current OS ( 2016)and SQL (2016) versions are going to obsolete and user wants to do inplace upgrade both OS and SQL to version 2022 . What is the best approach to perform inplace upgrade first . is it OS or SQL ? Could you please provide me the step by…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-08-07T10:32:00.48+00:00
Durga Tota 0 Reputation points
edited an answer 2025-08-07T21:46:53.3433333+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
1 answer

how to enable the Integration Services Catalogs node

I dont see the "Integration Services Catalogs"node option in my sql sever connection. how to enable this option in my server. i installed the developer edition and also have sql integration service

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,716 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
SQL Server | Other
asked 2024-07-22T02:44:00.19+00:00
Padmanaban U 0 Reputation points
commented 2025-07-25T23:18:12.34+00:00
Neha Jha 0 Reputation points
1 answer

not able to export database from azure database to onpremises

Hi, Iam not able to migrate database from azure database to on premises server, error is TITLE: Microsoft SQL Server Management Studio ------------------------------   One or more unsupported elements were found in the schema used as part of a data…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-07-25T08:11:06.2833333+00:00
Naga Durga Devi Kannuri - Admin 40 Reputation points
answered 2025-07-25T08:18:46.3233333+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
1 answer

Migrate Azure resources from one tenant to another tenant

Hi Team, I am looking for some guidance to know the best approach to migration Azure VM and other resources from one tenant to another tenant (we can consider a situation where company has been acquired or getting separated), what are the possible…

Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
949 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
Windows for business | Windows Server | Devices and deployment | Set up, install, or upgrade
asked 2023-10-20T11:50:56.3766667+00:00
Gautam Gulati 40 Reputation points
commented 2025-07-24T21:54:48.86+00:00
Pauline Thomas 0 Reputation points
1 answer

SSMA for Oracle to MS SQL - Need cons and pros

MIgration from oracle database to sql server need to know cons and pros to make sure is will working without any issue

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-07-14T20:41:22.1766667+00:00
Zuhair Malass 0 Reputation points
answered 2025-07-23T16:44:46.4433333+00:00
M V ADITYA KUMAR AKELLA 0 Reputation points
1 answer

Migrating database from old SQL & Windows Server to new SQL Server Edition

I plan to deploy the latest version of Windows Server 2025 alongside SQL Server 2024 Standard Edition. What are the recommended approaches and the sequence of steps for performing the migration with minimal downtime, if possible? When migrating a…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-07-18T05:55:06.9133333+00:00
EnterpriseArchitect 6,161 Reputation points
commented 2025-07-18T20:14:19.69+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
1 answer

We need to migrate a TDE-encrypted database from one Azure SQL Managed Instance to another Azure SQL Managed Instance. The standard TDE certificate export process (BACKUP CERTIFICATE) doesn't work on Managed Instance. Is there any supported method to expo

We need to migrate a TDE-encrypted database from one Azure SQL Managed Instance to another Azure SQL Managed Instance. The standard TDE certificate export process (BACKUP CERTIFICATE) doesn't work on Managed Instance. Is there any supported method to…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-07-09T18:33:45.5233333+00:00
Vansh Jain 0 Reputation points
answered 2025-07-09T21:41:48.59+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
0 answers

Error trying to use latest SQL Server Migration Assistant for Access

I have the latest SSMA for Access installed but can't get past a "New Workspace Error" either via the start wizard or trying to open a solution I created about 9 months ago. The error states "The type initializer for…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-06-17T11:07:16.47+00:00
Kevin Seerup 0 Reputation points
2 answers

SQL Server 2022 : Issue Restoring Database from 2014 Fails Without 'sysadmin' Role

We are attempting to restore a SQL Server 2014 database to SQL Server 2022. The process includes updating the database compatibility level from 120 (SQL 2014) to 160 (SQL 2022) after restoration. The issue we are encountering is: The restore and…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-06-12T06:28:17.4766667+00:00
Pagare, Ankit 0 Reputation points
answered 2025-06-12T17:32:40.31+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
0 answers

How to fix ODBC Driver Error "Invalid Character Conversion"

We are transferring data from sybase to mssql server, and the migration assistant is throwing "invalid character conversion" errors for some fields. These fields contain things like a degree symbol (alt-0176). I tried getting at the data…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-06-06T18:30:25.0066667+00:00
Hartman, Richard 0 Reputation points
commented 2025-06-06T20:58:44.97+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
0 answers

Microsoft SQL Server Migration Assistant for Oracle Extension Pack missing SSMA for Oracle Data Migration Assistant.dll

We installed SSMA for Oracle 10.1 and were trying to use the client side migration but it is calling for too much ram, so we tried to use the server side migration. However that fails immediately without much info as to why. We installed the…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-05-15T13:41:37.1833333+00:00
Straughn, Wayne 0 Reputation points
1 answer

Can I do an SQL Server Edition upgrade from Express to Developer on Azure VM?

I'm trying to upgrade an SQL Express database that comes with an application to SQL Developer edition. The machine is an Azure VM, not Azure SQL server instance. The application is Best Practice, a medical practice management software. The base…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-05-01T23:21:26.8166667+00:00
Melchor Buenaflor Admin 0 Reputation points
commented 2025-05-05T23:34:05.5266667+00:00
Melchor Buenaflor Admin 0 Reputation points
2 answers

Initialization error while migration assistance for MySQL

I am trying to migrate my MySQL database to MS SQL. I have already installed the ODBC driver and SSMA for MySQL. However I got an initialization error when trying to open SSMA. Cannot start because of an initialization error Try to restart the…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
SQL Server | Other
asked 2023-12-14T08:31:07.1233333+00:00
Chua Camille 0 Reputation points
answered 2025-04-17T15:46:33.5233333+00:00
Juan Villicana 10 Reputation points
1 answer

Unable to run SQL Server Migration Assistant for MySQL

I have installed SQL Server Migration Assistant for MySQL but it will start up. When I launch the program, it displays the splash screen and as it is displaying the message "Configuring Telemetry...", the program throws an exception. How can I…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
SQL Server | Other
asked 2024-02-27T00:20:41.68+00:00
John Wilson 15 Reputation points
answered 2025-04-17T15:50:45.35+00:00
Juan Villicana 10 Reputation points
1 answer

Unable to start Microsoft SQL Server Migration Assistant for Access

I have installed SQL Server Migration Assistant for Access, but it will not start up. When I launch the program, it displays the splash screen and as it is displaying the message "Configuring Telemetry...", the program throws an exception. How…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2024-04-24T04:58:52.4633333+00:00
Alister Oram 15 Reputation points
commented 2025-04-19T12:47:41.97+00:00
Adil Kocaosmanlar 0 Reputation points
2 answers One of the answers was accepted by the question author.

SQL Server Integration Services Projects 2022 exe for VS2022 is not detecting VS2022 and hence unable to install it

When i install SQL Server Integration Services Projects 2022, it does not detect my installed VS 2022. Hence, unable to select any VS and install. I tried from different machines.. in some machines its getting detected, but disabled, doesn't allow me to…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2024-04-29T10:52:06.8966667+00:00
SAILANATHAN Balaji 50 Reputation points
commented 2025-04-02T16:48:06.59+00:00
Sommercorn, Alan 0 Reputation points
0 answers

How to migrate app. to cloud server

My old school developer with only background in on-prem. deployment completed app. development for my small scale ready for deployment but I'm interested in cloud service server only thereby leaving scouting for solution to fully have the app. deployed.…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-04-18T22:52:07.9366667+00:00
Moses Ajoku 0 Reputation points
0 answers

How to Restore backup taken around 2007 using sql server 2005?

I want to restore a backup file taken around year 2007 using sql server 2005. When I trying to restore it using sql server 2022 it deliver me error message.

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-04-22T07:36:34.2866667+00:00
Sovan Bera 0 Reputation points
commented 2025-04-22T11:04:55.07+00:00
Olaf Helper 47,541 Reputation points
0 answers

udpStagingSweep Stored Procedure, commonly associated with Master Data Services (MDS) for managing staging data, is not available in SQL Server 2019.

Hi I am upgrading Master Data Services from 2012 to 2019, It appears that the udpStagingSweep stored procedure, commonly associated with Master Data Services (MDS) for managing staging data, is not available in SQL Server 2019. Over the major version…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-04-28T09:35:40.0566667+00:00
Shah, Syed 0 Reputation points
edited the question 2025-04-28T10:14:14.32+00:00
Shah, Syed 0 Reputation points
2 answers

Can SQL server 2022 user CALs be used on SQL Server 2017 Standard Server?

I have sql server 2017 installed with 10 sql 2017 user CALs, we need to add an additional 14 sql user Cal licenses but sql server 2017 CALS are no longer available only sql server 2022 user cals. Can we purchase 14 sql server 2022 cals and install it on…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
573 questions
asked 2025-05-04T19:39:27.2166667+00:00
TonCal 0 Reputation points
answered 2025-05-05T05:13:58.13+00:00
Olaf Helper 47,541 Reputation points