SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
553 questions
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.
asked 2025-02-25T17:27:56.8066667+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, 12%, 25%)' 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)
Mick Elkarim
20
Reputation points
edited the question 2025-02-27T21:43:05.12+00:00
Erland Sommarskog
117.8K
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…
asked 2025-02-26T17:19:32.09+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(204.8, 59%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
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 …
![](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, 12%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
0 answers
How to fix "The Remote Computer Refused the Network Connection"
Since upgrading to Windows 11, we got this issue connecting to a SQL Server 2019 using availability group listener. See full error below from SQL Management Studio. TITLE: Connect to Server Cannot connect to prdlsngaip,5039. ADDITIONAL INFORMATION: A…
asked 2025-02-24T14:38:20.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(176, 6%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM4%3C/text%3E%3C/svg%3E)
MariaRoselleAlbercaAlag-4848
0
Reputation points
commented 2025-02-24T21:53:15.6333333+00:00
Erland Sommarskog
117.8K
Reputation points MVP
3 answers
SQL Migration Office 365: DAO missing
Hello What I want to do: Migrate a acessdata.accdb to SQL Database 2019 with SSMA 8.14. OS, Office and SSMA are 64 bit. The error I get when loading the database: Retrieving the COM class factory for component with CLSID…
asked 2020-09-30T10:08:06.55+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, 67%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Monika Badertscher
6
Reputation points
answered 2025-02-23T20:10:08.7533333+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, 15%, 25%)' 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)
VadymLeliuk
1
Reputation point
0 answers
What is the SSMA XML construct to convert TEXT to VARCHAR, not NVARCHAR - to set invalid SQL dates to NULL
I am using SSMA for ACCESS and I want to use the console.EXE so that I can automate the migration of ~25 separate databases all to the same SQL Server instance. I am able to use the GUI to achieve the results that I want but I do not want ot have to…
asked 2025-02-23T17:15:46.52+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, 68%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWM%3C/text%3E%3C/svg%3E)
Wade McPherson
0
Reputation points
edited the question 2025-02-23T17:27:15.3633333+00:00
Erland Sommarskog
117.8K
Reputation points MVP
2 answers
SQL Server 16 Install
I am trying to install SQL Server 16. I run the install and it completes normally but when I create an instance it puts it under SQL Server 13 and if I try to restore from .BAK file in SSMS I get an error message that I .BAK file SQL Server 16 and cant…
![](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, 71%, 38%)' 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)
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
5
Reputation points
commented 2025-02-02T00:33:11.85+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(73.60000000000001, 50%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Malla, Cydrx Ian
0
Reputation points
2 answers
Using Azure Dms is it possible to migarte sql databse of 5Tb to azure Vm with ? What are limitations and known issues while migrating huge dbs to azure vm with azure DMS tool?
We are planning to migrate 5 Tb of sql db to azure Vm with help of azure DMS ? does dms support sql db with huge sizes like this? Azure Dms does supports only offline migration for azure vm . what is avg time taken by for migrating sql db with…
asked 2020-12-18T09:51:35.783+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(188.79999999999998, 97%, 28%)' 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)
Vishnuvardhan Settipally
6
Reputation points
commented 2025-01-28T12:22:42.5566667+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(41.6, 4%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Anubhav Malik
0
Reputation points
2 answers
Migration of SQL transfer from ver 2005 to 2008 SP2 with Restore failed with exceed limit of 10240MB
Good Day, I will like to ask question how do overcome the Restore failed with exceed limit of 10240MB
asked 2025-01-22T11:37:57.5633333+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, 68%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Siow, Jiong Cheng
0
Reputation points
answered 2025-01-23T03:16:55.48+00:00
LiHongMSFT-4306
30,826
Reputation points
1 answer
SSMA Tester Report Shows 0 Equivalent Tables in Migration from Sybase to MS SQL
The SSMA Tester results for migrating Sybase to MS SQL indicate "equivalent tables" as 0. SSMA Tester results shows success. What could be the reason for this outcome? The table comparison was set to "Full" in SSMA Tester, but the…
asked 2025-01-17T01:56:08.22+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(118.4, 33%, 21%)' 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)
Rajeskumar S L
20
Reputation points
answered 2025-01-17T01:56:08.23+00:00
Q&A Assist
0 answers
Unable to use dropdown menu to choose start date and end date column - SSIS SDC
Hi everyone, I am trying to set up a SDC in SSIS, but having trouble in the wizdard, the dropdown for both start date and end date are blank. I can't set up the SDC. Does anyone know how to fix this? Thanks!!!
![](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(243.2, 45%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
0 answers
Getting errot"Could not count rows in the target table after migration. Migration may have succeeded, but row count is not verified."
I use ssma for oracle application to migrate a big table(over 46M rows)from oracle database to sqlserver (sql server management studio). I followed these steps : 1.When I connect to sqlserver ,I change the target database name instead of the default…
![](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, 92%, 35%)' 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)
![](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, 37%, 27%)' 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)
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…
asked 2025-01-14T20:16:36.5733333+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, 64%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Michael Bowman
0
Reputation points
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. …
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
answered 2025-01-13T10:25:07.8166667+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(204.8, 77%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
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…
asked 2025-01-06T12:53:58.3333333+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(185.6, 41%, 27%)' 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)
Patankar, Narottam
20
Reputation points
commented 2025-01-09T09:31:47.47+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, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
1,485
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…
![](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(102.4, 92%, 19%)' 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)
3 answers
Can't restore databse on Microsoft SQL server management studio
=================================== Restore of database 'AdventureWorks2019' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) Program Location: at…
asked 2022-06-07T02:12:05.533+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, 37%, 11%)' 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)
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…
asked 2024-10-22T21:05:20.3966667+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
61
Reputation points
commented 2024-12-23T13:45:29.7833333+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(227.2, 83%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
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?
asked 2024-09-22T17:06:40.97+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(185.6, 88%, 27%)' 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)
Kevin Slack
5
Reputation points
commented 2024-12-17T13:25:29.1266667+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(128, 66%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sethu, Anoop (External)
0
Reputation points