579 questions with SQL Server Migration Assistant tags

Sort by: Updated
0 answers

How can I recover my purchased Microsoft SQL 2019 license?

Good morning, I purchased a Microsoft SQL Server license on August 20, 2021. Authorization number: [Moderator note: personal info removed] License number: [Moderator note: personal info removed] I need to reinstall the server using the license with its…

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.
579 questions
asked 2025-10-20T12:51:48.9533333+00:00
Marco Caroli 0 Reputation points
commented 2025-10-22T07:44:13.75+00:00
Chaithanya Kumar 0 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

How do i load sql database file into ssms

i have a sql database file from another computer. how do i load it into ssms on a new computer?

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.
579 questions
asked 2025-10-04T19:35:55.9066667+00:00
David Cutler 40 Reputation points
accepted 2025-10-06T15:42:35.6066667+00:00
David Cutler 40 Reputation points
1 answer

Provision of older versions (8 or 7) of SQL Server Migration Assistant (SSMA)

Microsoft サポートご担当者様 お世話になっております。 現在、SQL Server Migration Assistant(SSMA)のバージョン 8.0 または 7.x を入手したく、問い合わせさせていただきました。 弊社では、特定のレガシー環境との互換性の都合により、最新版(9.5や10.3)ではなく、旧バージョンの SSMA が必要となっております。 Microsoft…

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.
579 questions
asked 2025-10-06T01:22:59.6133333+00:00
Takigawa Tetsuya(滝川 哲也) 0 Reputation points
edited an answer 2025-10-06T12:42:38.2666667+00:00
Akhil Gajavelly 645 Reputation points Microsoft External Staff Moderator
10 answers One of the answers was accepted by the question author.

Could not find a part of the path 'C:\var\opt\mssql\Log\backuplog.txt' in SQL server on linux

Hello Team, I have installed SQL Sever on Linux and changed the log and data files locations as well. When I ran backup job and to view the backup job output file with SSMS when I click on view I am getting below error. Could not find a part of 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.
579 questions
SQL Server | Other
asked 2021-05-21T16:37:49.033+00:00
MJ Jakati 116 Reputation points
edited a comment 2025-09-30T08:29:57.7333333+00:00
ABDUL HAQ ABDUL LATHEEF 20 Reputation points
0 answers

workstations are not able to access server. Message is failed to generate user instance due to local application data path

Why are we getting this error from workstaions. The database and software both work on the server without issue. Does the workstations require a mapped drive? We are using the actual name of the server and the related SQL server for pathing. That…

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.
579 questions
asked 2025-09-18T22:41:24.12+00:00
Andrew Innes 51 Reputation points
commented 2025-09-19T16:33:23.99+00:00
Erland Sommarskog 127.4K Reputation points MVP Volunteer Moderator
0 answers

Master Data Service Upgrade Issue

Hi Team, we are trying to upgrade our Legacy SQL Server 2012 including MDS (Master Data Service) to SQL Server 2022. But, when upgrading the MDS Database to 2022 from 2012 using 'Master Data Service Configuration Manager', facing lot of issue like…

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.
579 questions
asked 2025-09-17T06:49:48.1533333+00:00
Srinivas Kalakonda (T) 0 Reputation points
commented 2025-09-17T21:25:54.35+00:00
Erland Sommarskog 127.4K Reputation points MVP Volunteer Moderator
0 answers

cant get SQL server to connect to SSMA

I don't know enough about SQL Server to really tell you what is going wrong, SSMA won't connect to anything I've downloaded SQL Express twice and I can't seem to get this thing to work, AI keep saying something about a .mof file I can't find on my…

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.
579 questions
asked 2025-08-28T21:26:31.44+00:00
Judy Graham 0 Reputation points
commented 2025-08-29T13:39:09.52+00:00
Erland Sommarskog 127.4K Reputation points MVP Volunteer Moderator
3 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.
579 questions
asked 2025-06-12T06:28:17.4766667+00:00
Pagare, Ankit 0 Reputation points
answered 2025-08-29T09:35:12.75+00:00
AJIN ANIYAN 0 Reputation points
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.
579 questions
asked 2025-05-15T13:41:37.1833333+00:00
Straughn, Wayne 0 Reputation points
commented 2025-08-25T13:09:29.4633333+00:00
Joseph, Gerald R 0 Reputation points
4 answers

Unable to install SQL server

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,099 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,742 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.
579 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,356 questions
SQL Server | Other
asked 2024-06-03T08:19:20.6533333+00:00
Cydrx Malla 5 Reputation points
answered 2025-08-23T06:59:41.1233333+00:00
Cydrx Malla 5 Reputation points
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.
579 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 127.4K 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,742 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.
579 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

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.
1,003 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.
579 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 45 Reputation points
commented 2025-07-24T21:54:48.86+00:00
Pauline Thomas 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.
579 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
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.
579 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 127.4K 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.
579 questions
asked 2025-06-17T11:07:16.47+00:00
Kevin Seerup 0 Reputation points
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.
579 questions
asked 2025-07-09T18:33:45.5233333+00:00
Anonymous
answered 2025-07-09T21:41:48.59+00:00
Erland Sommarskog 127.4K Reputation points MVP Volunteer Moderator
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.
579 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.
579 questions
asked 2025-07-18T05:55:06.9133333+00:00
EnterpriseArchitect 6,206 Reputation points
commented 2025-07-18T20:14:19.69+00:00
Erland Sommarskog 127.4K Reputation points MVP Volunteer Moderator
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.
579 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 127.4K Reputation points MVP Volunteer Moderator