507 questions with SQL Server Migration Assistant tags

Sort by: Updated
0 answers

Error Add-Migration ?

I'am student and I learn ASP.NET.CORE 6 MVC so I use Add-Migration in the Packed Manager Console. I see error No suitable constructor was found for entity type 'FilterDescriptor'. The following constructors had parameters that could not be bound to…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,344 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.
507 questions
asked 2024-02-22T11:14:49.4466667+00:00
LiaLia 0 Reputation points
commented 2024-02-29T07:59:28.83+00:00
Ping Ni-MSFT 3,115 Reputation points Microsoft Vendor
0 answers

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.
13,201 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.
507 questions
asked 2024-02-27T00:20:41.68+00:00
John Wilson 5 Reputation points
commented 2024-02-28T00:30:03.2166667+00:00
John Wilson 5 Reputation points
1 answer

O2SS0050 Conversion of Identifier not supported (CHAR, BINARY_INTEGER, BOOLEAN) is not supported

Hi, I've checked common conversion errors for Oracle Database to SQL Server 2016 migration with SSMA (https://video2.skills-academy.com/en-us/sql/ssma/oracle/messages/o2ss0007?view=sql-server-ver16) however this error is missing 02SS0050, Conversion of…

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.
507 questions
asked 2023-11-27T10:24:40.6033333+00:00
65877627 0 Reputation points
answered 2024-02-27T23:49:30.48+00:00
Greg Low 1,670 Reputation points Microsoft Regional Director
1 answer

Visual Studio 2022 Developer Edition Closes Immediately upon splash screen loading

After installing Visual Studio 2022 Developer Edition, upon loading the splash screen it closes immediately without any error prompts. Note: Application updated to the latest version.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,821 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.
507 questions
asked 2024-02-26T03:44:13.4566667+00:00
Joseph Antonio 0 Reputation points
answered 2024-02-26T06:49:54.93+00:00
Tianyu Sun-MSFT 28,941 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

SQL 2019 RTM issue

Hi, I have installed SQL Server 2019 (RTM) verion and want to install my System Center Service manager. But SCSM need supported ONLY SQL Server 2019 (CU8 or later), and NOT RTM version I dont have SQL Server 2019 only RTM How can I upgrade it or…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,201 questions
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.
2,855 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.
507 questions
asked 2024-02-19T10:03:03.62+00:00
PerserPolis-1732 1,516 Reputation points
commented 2024-02-19T21:47:00.2533333+00:00
Erland Sommarskog 105.8K Reputation points MVP
2 answers

Migration domain controllers and SQL server to Azure

Good day. I have a customer that wants to migrate their on-premises workloads to the cloud. They want to Migrate Domain controllers(they have 2), an SQL server, and a few other VMs to the cloud. All they have set up on the domains are AD, DNS, DHCP, and…

Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
744 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.
507 questions
asked 2024-02-16T21:08:53.33+00:00
Shadrick Francis 1 Reputation point
answered 2024-02-19T13:03:41.8766667+00:00
Net Runner 600 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.
13,201 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 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.
507 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,591 questions
asked 2021-04-05T06:10:44.777+00:00
Kumar, A. be 16 Reputation points
commented 2024-02-18T08:42:25.26+00:00
CF 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.
744 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.
507 questions
Windows Server Migration
Windows Server Migration
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Migration: The process of making existing applications and data work on a different computer or operating system.
413 questions
asked 2023-10-20T11:50:56.3766667+00:00
Gautam Gulati 20 Reputation points
commented 2024-02-09T06:14:55.8333333+00:00
SadiqhAhmed-MSFT 40,366 Reputation points Microsoft Employee
1 answer

SSMA Presenting ORA-01017: invalid username/password; logon denied

I am trying to leverage SSMA to migrate a oracle database to SQL or atleast get a migration assessment report. However every time I attempt to connect to the database I get the following error: Connection to Oracle failed. ORA-01017: invalid…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,201 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.
507 questions
asked 2023-11-28T11:49:11.5766667+00:00
Thomas Doughty 0 Reputation points
commented 2024-02-07T18:31:00.3666667+00:00
Amal Agarwal 5 Reputation points
5 answers

how to update SQL server 2012 to 2019

How do you update from old SQL server 2012 to 2019 without losing data?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,201 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.
507 questions
asked 2023-02-01T16:02:53.5866667+00:00
Jeremy Lopez 0 Reputation points
answered 2024-02-07T16:18:22.6466667+00:00
Muhammad Kamran 0 Reputation points
1 answer

Data Migration Assistant Tool- Security Considerations

Hi, I am performing the Data Migration from one sql server to another sql server using the Data Migration assistant tool. I am migrating highly confidential data , hence I want the data at rest and data at transit should be fully secure at each…

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.
507 questions
asked 2024-02-01T14:13:37.15+00:00
Rahul 251 Reputation points
commented 2024-02-05T14:50:06.4266667+00:00
Alberto Morillo 33,341 Reputation points MVP
1 answer

2007 Office System Driver Data Connectivity Components

I need 2007 Office System Driver Data Connectivity Components download but it says Microsoft took it down. I need it because you don't fully support SSIS in Visual studio 2022 yet. So I'm using Visual studio 2017 to build my SSIS packages with Excel…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,572 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 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.
507 questions
asked 2024-01-31T15:58:06.3566667+00:00
Micah Holmes 1 Reputation point
commented 2024-02-01T14:07:10.8666667+00:00
Micah Holmes 1 Reputation point
1 answer

Error in SSIS Package Execution - An error occurred when detecting the document payload kind (Microsoft.SqlServer.ManagedDTS)

I am encountering an issue in a SQL Server Integration Services (SSIS) package execution, and I would like to report the error for further investigation. The error message is as follows, URL sample…

SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
120 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.
507 questions
asked 2024-01-25T12:06:46.8833333+00:00
Prabhu 0 Reputation points
commented 2024-01-29T19:40:29.57+00:00
kobulloc-MSFT 25,731 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

Visual Studio "no project supported by NuGet" error

I am attempting to create a new SSIS package in Visual Studio and am getting this message when I try to open the NuGet Manager. I am using Visual Studio 2019 Version 16.11.33. This just started happening within the last couple of weeks.

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.
507 questions
asked 2024-01-23T18:58:37.6266667+00:00
Gronli, Brad 26 Reputation points
accepted 2024-01-24T13:05:34.7533333+00:00
Gronli, Brad 26 Reputation points
1 answer

Download file in AWS S3 bucket using SSIS

Is there a way to download a file from AWS S3 source to local using SSIS? I have files in different formats like json, csv that are sitting in ASW S3 and I would like to load the data in SQL Server On Prem using SSIS. The files comes in different names…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,201 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 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.
507 questions
asked 2024-01-21T21:05:43.86+00:00
Sinah Molepo 20 Reputation points
edited an answer 2024-01-22T03:43:34.54+00:00
ZoeHui-MSFT 34,836 Reputation points
3 answers

SSIS - when I open a solution, change the file name to load, the package freezes

Open Visual Studio SSIS Select project Click on Solution (mapping) When I do anything after that, I get a message "Visual Studio is busy. We'll automatically report ... " a) Change Excel Source b) Click on Data Flow c) Click on…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,201 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.
507 questions
asked 2024-01-11T15:33:20.1933333+00:00
Steve Thiboutot 0 Reputation points
answered 2024-01-12T15:11:21.4833333+00:00
Steve Thiboutot 0 Reputation points
3 answers

How to migrate a database from SQL Server 2000 to SQL server 2022 without paying for all the versions inbetween

Hi, We're currently running Microsoft SQL Server 2000 and would like to migrate to 2022 but to do this we have to iterate the database through multiple version of SQL server. Is it possible to get temporary licenses of all the version we need 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.
507 questions
asked 2024-01-10T12:54:31.9366667+00:00
Lester Kelly 20 Reputation points
edited an answer 2024-01-11T02:06:10.2733333+00:00
ZoeHui-MSFT 34,836 Reputation points
2 answers

Synchronizing data from Oracle 11.2 to SQL Server 2019

We are currently in the process of migrating from Oracle 11.2 to SQL Server 2019. We need a way to read data in our Oracle database on regular basis (nightly, daily, hourly, etc.) for synchronization purposes so that we can run reports against the 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.
13,201 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 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.
507 questions
asked 2023-08-15T18:47:09.5966667+00:00
Steve Hodgkiss 0 Reputation points
commented 2024-01-02T22:47:04.41+00:00
Maria Zulfiqar 0 Reputation points
2 answers One of the answers was accepted by the question author.

sql server migration assistant - mapping varchar to varchar

Hi! I am using SQL Server Migration Assistant for MySQL to migrate a database to SQL Server. However, trying to map the varchar type to varchar only leaves me with the nvarchar type? How do I adjust this?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 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.
13,201 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.
507 questions
asked 2023-12-28T12:39:38.2466667+00:00
Cesar Tomita 20 Reputation points
accepted 2023-12-28T17:32:03.8766667+00:00
Cesar Tomita 20 Reputation points
3 answers One of the answers was accepted by the question author.

SSIS Update unsupported

Hello! I am new to SSIS. I just recently updated my visual studio installer to the Visual Studio Community 2019 16.11.30. Once I updated this, I can no longer access my previous ssis packages. Attached I have a picture of the error of I am receiving.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,821 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.
13,201 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.
507 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
962 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
999 questions
asked 2023-09-20T15:31:45.4033333+00:00
Smith, Carl 20 Reputation points
accepted 2023-12-22T05:56:13.4166667+00:00
Smith, Carl 20 Reputation points