564 questions with SQL Server Migration Assistant tags

Sort by: Updated
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.
564 questions
asked 2025-05-01T23:21:26.8166667+00:00
Melchor Buenaflor Admin 0 Reputation points
answered 2025-05-02T05:39:43.66+00:00
Olaf Helper 46,631 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.
564 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
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.
564 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 46,631 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.
564 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
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.
564 questions
asked 2025-04-18T22:52:07.9366667+00:00
Moses Ajoku 0 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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 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.
564 questions
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
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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 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.
564 questions
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
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.
564 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
2 answers

where can I find Microsoft.ACE.OLEDB.12.0 Provider 64-bit

hello, We need the driver "Microsoft.ACE.OLEDB.12.0 Provider 64-bit", but it is no longer available! Could you provide me with a download link? Regards

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,726 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.
564 questions
asked 2024-04-19T01:28:50.96+00:00
Elham Khalaji 0 Reputation points
commented 2025-04-01T14:57:32.6733333+00:00
Yitzhak Khabinsky 26,491 Reputation points
1 answer One of the answers was accepted by the question author.

Prevent Automatic Migration of PostgreSQL Single Server to Flexible Server

Hi, Please confirm and ensure that no automatic migration will be attempted for the following PostgreSQL Single Server instance: We have already completed a manual migration of all databases to a new Flexible Server instance, and do not want Microsoft 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.
564 questions
asked 2025-03-29T13:41:46.25+00:00
David Barker 20 Reputation points
accepted 2025-03-29T14:06:39.3066667+00:00
David Barker 20 Reputation points
1 answer

How to change database's owner from user account to SA account where databases are in Availability group in the 4 node cluster.

Need to change database's owner from user account to SA account where databases are in Availability group in the 4 node cluster. Here my question is Is it a best practice to move the database owner to a 'sa' account or windows service account. …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 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.
564 questions
asked 2022-01-21T10:22:55.433+00:00
Sai 126 Reputation points
commented 2025-03-19T15:50:49.7066667+00:00
Zheng, Xiaogang 6 Reputation points
0 answers

Azure Data Migration dose not connect to the SQL server

Hello I have been using Azure Data migration service for the past couple of months with out issue Starting yesterday morning every time I try and create a new migration it fails to connect to the SQL server, I have checked the NSG and user details 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.
564 questions
asked 2025-03-19T09:53:57.2533333+00:00
Christian Hoare 0 Reputation points
1 answer

How to find the installation file for an older version of SQL Server Migration Assistant?

I need to migrate an Oracle database to SQL Server, but the current Oracle version is 11g, which is not supported by the latest version of SSMA for Oracle. How can I install a version of SQL Server Migration Assistant that supports Oracle 11g? SSMA 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.
564 questions
asked 2025-03-13T05:19:50.34+00:00
Vinh Dang Khanh 0 Reputation points
answered 2025-03-13T07:05:46.0166667+00:00
Olaf Helper 46,631 Reputation points
1 answer

I updated my sql to 2022, but most of the files in the shared folder are missing especially the mof files, sqlmgmprovider.mof

There were no errors when I installed the new SQL server. I am only using the sql server for SCCM. Thgere are only 2 files in the Shared folder. I cannot open the SSCM either Thanks Ricky

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.
564 questions
asked 2025-03-04T16:49:29.8533333+00:00
Ricky 0 Reputation points
edited an answer 2025-03-05T07:46:16.77+00:00
Olaf Helper 46,631 Reputation points
0 answers

Migrate database of around 250gbs from AWS rds to azure managed services

I want to migrate the database of around 250gbs from aws rds to azure managed services using azure database migrate service but as i create the service I am not able to select the source. source only showing the sql .

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.
564 questions
asked 2025-03-04T12:43:29.4833333+00:00
popopo 0 Reputation points
0 answers

SQL Server AOAG on multi subnet cluster using the same AD

Hi All, We have a SQL Server 3 node multi subnet cluster created having 2 node on production subnet and 1 disaster recovery (DR) node on another subnet but under the same domain/AD (One in Ohio and the other in NJ). What I know is that there should be…

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.
564 questions
asked 2025-03-03T14:51:53.7833333+00:00
Carlos D 51 Reputation points
edited the question 2025-03-03T14:58:13.69+00:00
Carlos D 51 Reputation points
1 answer One of the answers was accepted by the question author.

Is it possible to upgrade a WID (windows internal database) 2014 to 2016 and also how to apply security updates.

Is it possible to upgrade a WID (windows internal database) 2014 to 2016 and also how to apply security updates. provide details about 'WID' and also how to install 'WID' please provide any documents using GUI.

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.
564 questions
asked 2025-03-01T12:14:44.33+00:00
Anandhswarupp 165 Reputation points
accepted 2025-03-01T15:01:39.28+00:00
Anandhswarupp 165 Reputation points
1 answer One of the answers was accepted by the question author.

Will we continue to receive security updates after March 1st for SQL Server 2019

Hello, Will we continue to receive security updates after March 1st for SQL Server 2019? Thanks.

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.
564 questions
asked 2025-02-25T17:27:56.8066667+00:00
Mick Elkarim 20 Reputation points
edited the question 2025-02-27T21:43:05.12+00:00
Erland Sommarskog 120.3K Reputation points MVP
0 answers

Can't uninstall SQL 2022

First Q&A made me select a child tag and none applied, so since I was trying to upgrade from 2019 express to 2022 express unsuccessfully, I selected Migration Assistant. My installation got stuck on sql engine core, and the only Q&A I found…

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.
564 questions
asked 2025-02-26T17:19:32.09+00:00
White, Susan 0 Reputation points
commented 2025-02-27T13:09:09.7033333+00:00
White, Susan 0 Reputation points
1 answer

I have this error while Connect SQL SERVER DATABASE for LARAVEL PROJECT

1 vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:66 PDOException::("SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Timeout error [258]. ") ``` 2 …

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.
564 questions
asked 2025-02-25T11:18:05.84+00:00
Ravi M 0 Reputation points
commented 2025-02-26T10:35:14.26+00:00
Ravi M 0 Reputation points