585 questions with SQL Server Migration Assistant tags

Sort by: Updated
1 answer

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.
585 questions
asked 2025-05-15T13:41:37.1833333+00:00
Straughn, Wayne 0 Reputation points
commented 2025-12-05T11:55:18.8433333+00:00
Lakshmi Narayana Garikapati 640 Reputation points Microsoft External Staff Moderator
2 answers

Need SSMA 32bit (10.3 version)

Hello, I urgently need SQL Server Migration Assistant (SSMA) version 10.3 (32-bit). The current download link only provides version 10.4, but this release introduces regressions that break my workflow. Version 9.5 is too old for my environment, so 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.
585 questions
asked 2025-12-02T06:55:12.3333333+00:00
Wynton Coetzee 0 Reputation points
commented 2025-12-04T20:19:52.0866667+00:00
Viorel 125.6K 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.
585 questions
asked 2025-07-14T20:41:22.1766667+00:00
Zuhair Malass 0 Reputation points
commented 2025-12-04T10:14:10.8433333+00:00
Singam shetty Sri ganesh 80 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

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.
585 questions
asked 2025-07-18T05:55:06.9133333+00:00
EnterpriseArchitect 6,301 Reputation points
commented 2025-12-02T23:41:24.5333333+00:00
EnterpriseArchitect 6,301 Reputation points
1 answer

Upgrade from SQL-Server 2019 Standard to SQL-Server 2022 Standard

I want to make an upgrade from SQL-Server 2019 Standard to SQL-Server 2022 Standard. But i can't check the button for the standard edition. Best regards Carsten Neuhaus IKN GmbH

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.
585 questions
asked 2025-11-25T11:45:42.41+00:00
Carsten Neuhaus 0 Reputation points
commented 2025-12-02T05:18:01.5+00:00
Akhil Gajavelly 875 Reputation points Microsoft External Staff Moderator
0 answers

How can I get my Server and SQL authorization back?

I can provide the authorization number and usage right number. How can I retrieve the product registration account and authorization?

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.
585 questions
asked 2025-12-01T09:37:18.8166667+00:00
楊振福 0 Reputation points
commented 2025-12-02T00:04:28.9566667+00:00
楊振福 0 Reputation points
2 answers

Need Archived Installer for SSMA 10.3

Hi, I’m running SQL Server 2022 Express on Windows 10 (64‑bit) and using SSMA for Access. With SSMA 10.4, I keep getting the error “Bad parameters for connection” when connecting via Windows Authentication. I understand this is a known regression in…

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.
585 questions
asked 2025-11-29T19:05:58.6566667+00:00
Mario Jaile 41 Reputation points
answered 2025-12-01T05:37:17.88+00:00
Akhil Gajavelly 875 Reputation points Microsoft External Staff 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.
585 questions
asked 2025-06-12T06:28:17.4766667+00:00
Pagare, Ankit 0 Reputation points
commented 2025-12-01T05:30:26.5833333+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
3 answers

SSMA for Db2 cannot connect to Db2 running on AIX.

SSMA for Db2 cannot connect to Db2 running on AIX. connection string is: Provider=DB2OLEDB;Password=[password];Persist Security Info=True;User ID=[UserId];Initial Catalog=[DB Name];Data Source=[DB Name];Authentication=Server_Encrypt_Pwd;Network…

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.
585 questions
asked 2025-11-20T02:22:21.9466667+00:00
Ikuo Takekawa/竹川 育夫 0 Reputation points
commented 2025-11-21T08:26:54.75+00:00
Ikuo Takekawa/竹川 育夫 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.
585 questions
asked 2025-07-25T08:11:06.2833333+00:00
Naga Durga Devi Kannuri - Admin 40 Reputation points
commented 2025-11-20T11:40:15.9933333+00:00
Vinay Kumar Eshwara 5 Reputation points Microsoft External Staff Moderator
1 answer

SQL Express 2022 Installation is failing with error code - 2068052310

SQL Express 2022 Installation is failing with error code - 2068052310

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.
585 questions
asked 2025-11-05T15:45:54.0033333+00:00
Ron Golini 0 Reputation points
answered 2025-11-13T06:36:12.9266667+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
1 answer

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.
585 questions
asked 2025-09-17T06:49:48.1533333+00:00
Srinivas Kalakonda (T) 0 Reputation points
commented 2025-11-13T05:29:50.6866667+00:00
Nithin Krishna Madadi 0 Reputation points Microsoft External Staff Moderator
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.
585 questions
asked 2025-08-07T10:32:00.48+00:00
Durga Tota 0 Reputation points
commented 2025-11-12T12:12:21.83+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
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.
585 questions
asked 2025-10-20T12:51:48.9533333+00:00
Marco Caroli 0 Reputation points
commented 2025-11-06T05:09:04.2166667+00:00
Chaithanya Kumar 0 Reputation points Microsoft External Staff Moderator
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.
585 questions
asked 2025-09-18T22:41:24.12+00:00
Andrew Innes 51 Reputation points
commented 2025-10-31T10:09:43.37+00:00
Dinesh Yadlapalli 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.
585 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.
585 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 875 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.
585 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 25 Reputation points
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.
585 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 128.6K Reputation points MVP Volunteer Moderator
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,116 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,758 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,365 questions
SQL Server | Other
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.
585 questions
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