SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
502 questions
2 answers
ORA-01017 Error in SSMA for Oracle
I am trying to leverage SSMA for Oracle and am running to an ORA-01017: Invalid username/password; logon denied error when trying to connect to the Oracle dB. A UDL connection to the Oracle dB from the same machine and with the same credentials works…
asked 2023-10-23T19:10:20.1066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 47%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Keith Steflik
0
Reputation points
answered 2024-04-03T09:21:48.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 70%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mihocka, Martin
0
Reputation points
1 answer
SSIS Send Mail Task Fails on Out of office
I have a simple Send Mail Task that sends an email to a list of dynamic users. If one of those users has "out of office" set, the SSIS flow fails. The next day, when it sends again, it works, because "out of office" doesnt respond…
asked 2024-03-25T13:11:29.8966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 30%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mark Lewin
0
Reputation points
commented 2024-03-28T13:35:58.5233333+00:00
Mark Lewin
0
Reputation points
1 answer
Connection to ACCESS database fails with exception: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Connection to ACCESS database fails with exception: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine How can i solve this problem ? Please guide me
asked 2024-03-27T05:21:59.99+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 54%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHT%3C/text%3E%3C/svg%3E)
himanshu tripathi
0
Reputation points
answered 2024-03-27T13:59:10.2733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,286
Reputation points
3 answers
unable to uninstall sql server 2019
while uninstalling sql server the below error is popping up kindly help
asked 2023-01-22T06:48:48.7666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 88%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Madhusudhan
0
Reputation points
commented 2024-03-26T14:06:35.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 62%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Leo R
0
Reputation points
2 answers
Struggling with SSIS lookup date key transformation
How do i fix the below error, i have confirmed a million times that the data type is the same. The date formats are different though. Could that be the problem
asked 2024-03-21T12:09:24.4733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Susan Gatura
0
Reputation points
answered 2024-03-22T01:31:06.7566667+00:00
ZoeHui-MSFT
34,186
Reputation points
1 answer
Transaction Log is full due to 'ACTIVE_TRANSACTION'
Hi While migrating data from a Sybase SQL server to MS SQL Server uusing SSMA for Sybase v9.4 I found about 40 errors showing: Errors: The transaction log for database 'MyDatabase' is full due to 'ACTIVE_TRANSACTION'. In result I believe the migration…
asked 2024-03-19T17:27:24.1966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 40%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Tahir Khalil
41
Reputation points
answered 2024-03-19T19:24:18.6266667+00:00
Olaf Helper
42,286
Reputation points
2 answers
Not able to add sql server to west europe location, while my azure portal students account is based in the Netherlands.
I'm not able to create a sql server in west europe, but i am able to create servers in other regions using my azure for students account. Using other regions costs too much for data transfer between regions. Would anyone know the solution or why i can't…
asked 2024-03-10T12:29:30.1366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 69%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Rens van der Burg (1034400)
5
Reputation points
answered 2024-03-15T08:02:58.4133333+00:00
Mert Cakir
0
Reputation points
1 answer
Issues with SQL failover cluster on windows 2016 migration
Hi, We are in the process of migrating our windows server 2012 servers to 2019 and we are using failover cluster to maintain our SQL always on. As we know , it's only possible to get to 2019 through windows 2016 for compatibility reasons and i'm familiar…
asked 2024-03-12T12:52:37.3433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 45%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYN%3C/text%3E%3C/svg%3E)
Yishai Neeman
20
Reputation points
answered 2024-03-14T12:31:09.75+00:00
Yishai Neeman
20
Reputation points
2 answers
One of the answers was accepted by the question author.
How upload a file from my pc in sharepoint online
Hi, I create a ssis that produce a file xls test.xlsx, saved in a local directory of my pc. Then I would like to copy this file in a sharepoint online es.…
asked 2024-03-01T11:15:38.9466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 0%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Donatella Candelo
20
Reputation points
answered 2024-03-14T09:20:01.5533333+00:00
Donatella Candelo
20
Reputation points
2 answers
PC OS clean install. How to transfer SQL license?
Have this SQL server: Microsoft SQL Server 2017 Enterprise Edition: Core-based Licensing (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 17763: ) And trying to update windows to windows 11. Is there a way to transfer the SQL license? Thanks.
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,902 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,005 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.
502 questions
asked 2024-03-12T18:44:41.35+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 92%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Alec Sim
0
Reputation points
answered 2024-03-13T02:54:52.0533333+00:00
CosmogHong-MSFT
24,186
Reputation points Microsoft Vendor
2 answers
Date Datatype Issue in the Lookup in SSIS
Hello, I map "date" information obtained from the Excel source in SSIS (1.3.2 version) through the Data Conversion Transformation Editor with the 'database date' data type In Date Lookup Transformation Editor, I use the Date_Dim table and the…
asked 2024-03-07T21:06:11.9466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 72%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mustafa SEVER
0
Reputation points
edited an answer 2024-03-09T21:51:33.56+00:00
Mustafa SEVER
0
Reputation points
4 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…
asked 2023-11-07T23:13:16.0566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 1%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
veera
0
Reputation points
commented 2024-03-09T03:32:43.0433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 4%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Ricardo Silva
6
Reputation points
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…
asked 2024-02-22T11:14:49.4466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 16%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LiaLia
0
Reputation points
commented 2024-02-29T07:59:28.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 61%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Ping Ni-MSFT
2,560
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…
asked 2024-02-27T00:20:41.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 28.000000000000004%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
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://learn.microsoft.com/en-us/sql/ssma/oracle/messages/o2ss0007?view=sql-server-ver16) however this error is missing 02SS0050, Conversion of…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 84%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E6%3C/text%3E%3C/svg%3E)
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,741 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.
502 questions
asked 2024-02-26T03:44:13.4566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 15%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Joseph Antonio
0
Reputation points
answered 2024-02-26T06:49:54.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tianyu Sun-MSFT
28,341
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…
asked 2024-02-19T10:03:03.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 43%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP1%3C/text%3E%3C/svg%3E)
PerserPolis-1732
1,436
Reputation points
commented 2024-02-19T21:47:00.2533333+00:00
Erland Sommarskog
102.9K
Reputation points
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…
asked 2024-02-16T21:08:53.33+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 27%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
Shadrick Francis
1
Reputation point
answered 2024-02-19T13:03:41.8766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 24%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENR%3C/text%3E%3C/svg%3E)
Net Runner
595
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…
asked 2021-04-05T06:10:44.777+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 81%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kumar, A. be
16
Reputation points
commented 2024-02-18T08:42:25.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 87%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
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…
asked 2023-10-20T11:50:56.3766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 80%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Gautam Gulati
15
Reputation points
commented 2024-02-09T06:14:55.8333333+00:00
SadiqhAhmed-MSFT
39,566
Reputation points Microsoft Employee