544 questions with SQL Server Migration Assistant tags

Sort by: Updated
0 answers

Getting errot"Could not count rows in the target table after migration. Migration may have succeeded, but row count is not verified."

Trying to migrate one table from Oracle 19 to MS SQL 2019 and one table keeps failing with the error: "Could not count rows in the target table after migration". I tried resetting the 'data migration timeout' from 15 to 600 but looks like it…

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.
544 questions
asked 2025-01-14T20:16:36.5733333+00:00
Michael Bowman 0 Reputation points
1 answer

Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

This is the error message I receive when I run a SSIS package. Only one particular server is causing this issue other servers are connecting and package is getting executed. Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. …

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.
544 questions
asked 2024-06-19T02:01:51.49+00:00
Noopura Jaiswal 0 Reputation points
answered 2025-01-13T10:25:07.8166667+00:00
Christian Giangrande 0 Reputation points
3 answers

On-prem MS SQL server 2016 migration to Azure SQL Server Managed database Instances path

Hi Team, We are currently planning to migrate our On-prem MS SQL Server 2016 to Azure SQL Server Managed Database Instances. The source will be our On-prem MS SQL Server 2016, and the target is the Azure SQL Server Managed Database Instances. I have a…

Azure SQL Database
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.
544 questions
asked 2025-01-06T12:53:58.3333333+00:00
Patankar, Narottam 20 Reputation points
commented 2025-01-09T09:31:47.47+00:00
Vijayalaxmi Kattimani 905 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

SQL server with Trace flags 2371 and 7745

Hi Team, We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes…

Azure Database Migration service
Azure SQL Database
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,290 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.
544 questions
asked 2024-12-20T10:18:09.9266667+00:00
Sanjeev K 40 Reputation points
accepted 2025-01-08T08:15:30.3366667+00:00
Sanjeev K 40 Reputation points
3 answers

Can't restore databse on Microsoft SQL server management studio

=================================== Restore of database 'AdventureWorks2019' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) Program Location: at…

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,290 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.
544 questions
asked 2022-06-07T02:12:05.533+00:00
Manwinder Singh 1 Reputation point
commented 2025-01-05T23:48:41.09+00:00
Amin Abd Allah Yahya Alhaj 0 Reputation points
2 answers

SSMA for Sybase truncating image data type to 32768

Hi, I am using SSMA for Sybase to migrate Sybase ASE 16 database to MS SQL Server 2022 on Linux. A table with image type column is migrated but the data in this column limited to 32768. I believe if this data migration program is using bcp - it might be…

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,290 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.
544 questions
asked 2024-10-22T21:05:20.3966667+00:00
Tahir Khalil 61 Reputation points
commented 2024-12-23T13:45:29.7833333+00:00
Pieter Coene 0 Reputation points
1 answer

SSMA says my SQL Server agent isn't running, but it is.

When connecting to my target SQL instance, on the same server as SSMA, it gives me a warning that SQL Server Agent isn't running and must be up. However, it is up and running. What is it looking for, and how do I get it to recognize the actual status?

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.
544 questions
asked 2024-09-22T17:06:40.97+00:00
Kevin Slack 5 Reputation points
commented 2024-12-17T13:25:29.1266667+00:00
Sethu, Anoop (External) 0 Reputation points
1 answer

linked services using integration runtime

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'JOEL\SQLEXPRESS03', Database: 'AdventureWorksLT2022', User: 'joel4'. Check the linked service configuration is correct, and make sure the SQL Database firewall…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,107 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.
544 questions
asked 2024-12-02T04:46:57.98+00:00
Thierry Joel Meli Tchinda 0 Reputation points
answered 2024-12-09T04:47:52.72+00:00
ShaktiSingh-MSFT 16,171 Reputation points
2 answers

Possibity of upgrade and migration from SQL 2014 to SQL 2022

HI Team, I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way. Kind 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,290 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.
544 questions
asked 2024-11-15T08:49:17.6066667+00:00
Tarik sendro 0 Reputation points
commented 2024-11-22T14:37:11.7166667+00:00
Tarik sendro 0 Reputation points
1 answer

Upload to Azure Migrate - Error AADSTS16000

I am using the latest version of Data Migration Assistant. Once I finish the assessment of a local SQL Server instance and try to upload the assessment to Azure migrate, I get this error after signing in to my Azure account. I can log into the portal and…

Azure Database Migration service
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.
544 questions
asked 2024-11-15T06:26:16.32+00:00
agam chauhan 0 Reputation points
answered 2024-11-15T06:53:31.8266667+00:00
Abiola Akinbade 21,780 Reputation points
5 answers

SSIS not inserting all rows from ODBC (oracle) to SQL server 2019

I have an issue with migration to SQL server 2019. My Source is Oracle and my Destination is Microsoft SQL Server 2019. My package consists of a simple Data Load task; ODBC Source Connection(oracle)/ and OLE DB Destination connection(2019 SQL…

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,290 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,628 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.
544 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,675 questions
asked 2021-04-05T06:10:44.777+00:00
Kumar, A. be 16 Reputation points
commented 2024-11-14T06:34:08.11+00:00
Maxwell Hartono 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to migrate large Sybase database using SSMA for Sybase

We are on Sybase/SAP ASE database of various sizes the larges one contains about 1TB of data. We are testing the migration it to on-premise MS SQL Server 2022 Linux, using SSMA for Sybase. Our concern is to move the full data during the downtime which…

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,290 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.
544 questions
asked 2024-11-04T17:31:34.44+00:00
Tahir Khalil 61 Reputation points
accepted 2024-11-05T12:25:11.78+00:00
Tahir Khalil 61 Reputation points
1 answer

DMA tool compliance

Hi Team, We are planning to do some assessments using DMA but i am unable to find any good document for compliance issues for DMA. Can you please help to find the DMA compliance. How to make sure DMA is compliance and safe tool for assessments.

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,290 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.
544 questions
asked 2024-11-01T06:26:36.4866667+00:00
Sanjeev Reddy 30 Reputation points
commented 2024-11-04T06:23:46.93+00:00
Sanjeev Reddy 30 Reputation points
2 answers

Error at oled destination

TITLE: Package Validation Error Package Validation Error ADDITIONAL INFORMATION: Error at Package: The connection "{ED0A6B78-CF34-429E-86CF-4E157EE8CD5E}" is not found. This error is thrown by Connections collection when the specific…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,628 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.
544 questions
asked 2024-10-23T17:40:08.2066667+00:00
Siqi Zhao 0 Reputation points
edited an answer 2024-10-27T01:57:45.6966667+00:00
Yitzhak Khabinsky 26,296 Reputation points
0 answers

Azure Managed Instance Migration offline mode. Cannot find full back up error

I am trying to my migrate my on-prm sql server to SQL managed instance via Azure Data Studio Managed instance. I am using the offline mode to migrate the server and my back up files are saved in blob starage account. When i initate the migration i get an…

Azure Database Migration service
Azure SQL Database
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.
544 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
128 questions
asked 2024-08-02T18:55:23.06+00:00
Hossain, Shakir 21 Reputation points
commented 2024-10-23T22:03:30.4533333+00:00
Oury Ba-MSFT 19,996 Reputation points Microsoft Employee
2 answers

we are trying to migrate the database from 2019 express edition to 2017 enterprise edition , pls suggest which POA is best , how we will do this activity without any error .

we are trying to migrate the database from 2019 express edition to 2017 enterprise edition , pls suggest which POA is best , how we will do this activity with any error . we will plan for migration through data tier application but we have one issue…

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,290 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.
544 questions
asked 2024-10-17T09:40:46.94+00:00
Srinivas Naraipeddi 40 Reputation points
commented 2024-10-22T21:36:22.71+00:00
Erland Sommarskog 115.3K Reputation points MVP
1 answer

How to run SSIS packages using Execute package activity in ADF Pipeline, When the package contains a script file that uses .exe files

Hi Team, we are migrating our on-prem databases to Azure Sql managed Instance and as a part of migration we wanted to run our ssis packages in ADF using Execute SSIS package activity. But in our SSIS packages we have some script task which are using…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,107 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.
544 questions
asked 2024-10-09T08:48:16.89+00:00
commented 2024-10-14T18:59:08.2966667+00:00
Chandra Boorla 6,460 Reputation points Microsoft Vendor
5 answers

Issues in using Microsoft.Data.SqlClient in SSIS project

I have installed visual studio 2022 image and installed SQL Server Integration Services Projects 2022. I am trying to implement functionality of ado.net using Microsoft.Data.SqlClient and running into below issues. ADO NET Destination has failed 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.
544 questions
asked 2023-11-07T23:13:16.0566667+00:00
veera 0 Reputation points
answered 2024-10-08T15:47:17.0333333+00:00
Luis Martinez 0 Reputation points
1 answer

VBscript not running on windows server 2019

Hi All, Our VB Script has been integrated with SSIS package as script task and it work in fine in visual studio IDE . However, it is getting failed to run same VB script block in windows server 2019 environment inside SSISB as a SSIS Package. Please…

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,290 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.
544 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,765 questions
asked 2024-10-01T22:49:57.54+00:00
MasterSQL 0 Reputation points
commented 2024-10-07T02:25:35.6066667+00:00
Jiale Xue - MSFT 48,686 Reputation points Microsoft Vendor
2 answers

I got an error that I cannot connect to SQL while demoing olap.Help me repair this error,please.

Please help me fix the following error

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,961 questions
Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
7,707 questions
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,290 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.
544 questions
asked 2024-10-02T10:16:50.4933333+00:00
võ thị tuyết ngân 20 Reputation points
answered 2024-10-07T01:45:23.6366667+00:00
ZoeHui-MSFT 39,496 Reputation points