SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
510 questions
1 answer
I created a SSIS package to fetch data from an API to store in the Data Warehouse. But I am getting the runtime error in my script task. I even used try/catch to figure out the error, but nothing is working.
Additionally, I am using a variable 'Token' which I declared in ReadWriteVariables. The error - at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at…
SQL Server Migration Assistant
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,605 questions
asked 2024-07-13T01:33:03.4633333+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, 9%, 14%)' 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)
Manmohit Singh
0
Reputation points
answered 2024-07-16T07:38:37.9433333+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(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT
42,401
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Workday and alternative
Hi, I have a table which needs to duplicate with weekday and alternative create table table3 ( col1 varchar(20) , col2 varchar(20)) expected results Insert into table1 values('catch', 'catch1') …
![](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(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
2 answers
Use SQL Server 2022 License Key to Install SQL Server 2019
Hi, I have installed SQL Server 2019 on our cloud EC2 Windows server machine using the SQL Server Evaluation Edition with a 180-day free trial. We intend to purchase the SQL Server 2022 Standard Edition key. Can we use this key to activate the SQL Server…
asked 2024-07-11T09:43:23.8833333+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(179.20000000000002, 89%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
surya kannan
0
Reputation points
answered 2024-07-12T06:19:32.4533333+00:00
MikeyQiaoMSFT-0444
1,750
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
asked 2024-04-19T01:28:50.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(192, 68%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Elham Khalaji
0
Reputation points
commented 2024-07-04T11:11:44.27+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, 2%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Chandrasekar N
0
Reputation points
7 answers
How to resolve this "Microsoft.ReportingServices.WmiProvider.WMIProviderException:...." error?
I keep getting this error. Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is…
asked 2021-05-10T21:06:09.8+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(275.2, 3%, 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)
CharlieLor
551
Reputation points
commented 2024-07-04T03:49:54.77+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(240, 46%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ryan
0
Reputation points
3 answers
Choose columns during migration when using SSMA
Is it possible to select specific columns when we migrate data from source to target in SSMA? Basically, I am getting error while migrating table data which contains computed columns in source side. So I was looking for either excluding the column…
asked 2021-02-09T19:57:55.623+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, 26%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Siddhesh Manjrekar
1
Reputation point
commented 2024-07-03T15:43:13.9766667+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(220.8, 73%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Pinky Rajan
0
Reputation points
2 answers
How do I back up a SQL database to Azure from Microsoft SQL Server Management Studio
I don't have access to the Azure portal to do it from that instance. I need to migrate the database to another server
asked 2024-06-19T21:08:18.42+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(275.2, 82%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sergio Sanchez
0
Reputation points
commented 2024-07-02T19:50:43.9666667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Migrate from DB2 to Azure Database for PostgreSQL/MySQL/MariaDB
Hi, Is it possible to migrate a DB2 database to Azure database for PostgreSQL/MySQL or MariaDB? Thanks for the helping and documentation to do this process. Cordially, Albeiro Jiménez López
asked 2023-11-02T16:25:02.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(9.6, 66%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Albeiro Jimenez Lopez
20
Reputation points
commented 2024-07-01T17:08:09.08+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(288, 48%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUP%3C/text%3E%3C/svg%3E)
Uliana Philippova
0
Reputation points
4 answers
Data (of 15GB) from SQL 2000 to SQL 2012 via SQL 2008 - Express okay? Trial versions?
I'm trying to move a backup data (of 15gb) from SQL 2000 to SQL 2012. To do so, I must go thru SQL 2008 (or 2005), that is, A. Restore 2000-backup-file into 2008. B. Create 2008-backup-file. C. Restore 2008-backup-file into 2012. I've been looking for…
asked 2024-06-13T22:16:33.8266667+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(144, 69%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
David
0
Reputation points
commented 2024-06-25T21:15:28.99+00:00
Erland Sommarskog
1.1L
Reputation points MVP
3 answers
SSMA stopped working when we upgraded source database to MariaDB 10.11.x, how can we resolve this?
We are working on migrating from an Azure MariaDB to SQL Server on an Azure VM. The process was working until we upgraded MariaDB from 10.6.x to 10.11.x. Now we get an error stating, "Error occurred while collecting data". Additional error in…
asked 2024-06-06T16:36:10.5+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(281.6, 98%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mark Daugherty
0
Reputation points
accepted 2024-06-25T20:35:05.2033333+00:00
Mark Daugherty
0
Reputation points
0 answers
SSMA for DB2 to SQL migration errors - No Authorized routine named 'getvariable' of type 'Function' having compatible arguments was found.
While connecting to DB2 using SSMA getting below eeror : Error occured while collecting data . [Db2/LINUXX8664] SQL0440N No authorized routine named 'GetVariable" of type "Function" having compatible arguments was found. SQLSTAE-42884
asked 2024-06-25T15:27:36.86+00:00
Pinky Rajan
0
Reputation points
asked 2024-06-25T15:27:36.86+00:00
Pinky Rajan
0
Reputation points
1 answer
There was an error trying to establish an Oracle connection with the database server
TITLE: Microsoft Visual Studio There was an error trying to establish an Oracle connection with the database server. Getting this error while trying to establish connection to Oracle is SSIS ConnectionManager. Tried to connect using…
asked 2024-06-21T15:03:49.6566667+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(156.8, 47%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jobin, Priscilla
0
Reputation points
commented 2024-06-25T12:43:48.6633333+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,726
Reputation points
0 answers
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. …
asked 2024-06-19T02:01:51.49+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(214.4, 93%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Noopura Jaiswal
0
Reputation points
asked 2024-06-19T02:01:51.49+00:00
Noopura Jaiswal
0
Reputation points
1 answer
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…
asked 2024-04-29T10:52:06.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(316.8, 78%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
SAILANATHAN Balaji
40
Reputation points
accepted 2024-06-10T04:46:36.1666667+00:00
SAILANATHAN Balaji
40
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server Migration Assistant for MySQL download page 404s
Hi, I was trying to download the SQL Server Migration Assistant for MySQL tool, but the link to download the latest version of the tool leads to a 404 page. See https://aka.ms/ssmaformysql, and this page was last updated in mid-late 2023 and has no…
asked 2024-06-05T20:12:20.2533333+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(12.8, 65%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Matthew Frederick
20
Reputation points
edited a comment 2024-06-06T11:05:39.6166667+00:00
Viorel
1.1L
Reputation points
3 answers
asked 2024-06-03T08:19:20.6533333+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, 46%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cydrx Malla
0
Reputation points
commented 2024-06-06T03:28:25.09+00:00
MikeyQiaoMSFT-0444
1,750
Reputation points
0 answers
TITLE: Connection Manager. The specified provider is not supported. Please choose different provider in connection manager. This error occurs when i try to configure ole db manager.
TITLE: Connection Manager The connection string is not valid. BUTTONS: OK this error comes up when i try to keep the provider as native ole db\microsoft ole db provider for sql server
asked 2024-06-04T17:35:31.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(284.8, 6%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pranav
0
Reputation points
commented 2024-06-04T20:54:08.55+00:00
Erland Sommarskog
1.1L
Reputation points MVP
0 answers
How to fix Could not load file or assembly 'Ionic.Zip, Version=1.9.1.8, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c' or one of its dependencies erro
I am opening SSIS 2008 package on new Microsoft windows server 2019 datacenter ,for opening i am using sql server datatools 2019(VS2019) I added all the references of external DLL's but still getting System.IO.FileNotFoundException: Could not load file…
asked 2024-06-03T09:44:43.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(300.8, 25%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Rohit Tandon
0
Reputation points
edited the question 2024-06-04T01:30:50.2466667+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(249.60000000000002, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
27,731
Reputation points Microsoft Vendor
0 answers
How to fix error Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host?
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host, I need to get data from microsoft project on line to moicrosoft SQL database
asked 2024-06-03T11:52:47.1866667+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(297.6, 9%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Mostafa Elframawy
0
Reputation points
commented 2024-06-03T21:34:56.9633333+00:00
Erland Sommarskog
1.1L
Reputation points MVP
0 answers
SSMA for Mysql Console Migration
The migration was successful in SSMA gui. But not on the console. It's a script I wrote <?xml version="1.0" encoding="utf-8"?> <ssma-script-file xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"…
![](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(240, 50%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
![](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(214.4, 28.000000000000004%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)