SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
557 questions
1 answer
I updated my sql to 2022, but most of the files in the shared folder are missing especially the mof files, sqlmgmprovider.mof
There were no errors when I installed the new SQL server. I am only using the sql server for SCCM. Thgere are only 2 files in the Shared folder. I cannot open the SSCM either Thanks Ricky
asked 2025-03-04T16:49:29.8533333+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, 19%, 27%)' 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)
Ricky
0
Reputation points
edited an answer 2025-03-05T07:46:16.77+00:00
Olaf Helper
46,201
Reputation points
0 answers
Migrate database of around 250gbs from AWS rds to azure managed services
I want to migrate the database of around 250gbs from aws rds to azure managed services using azure database migrate service but as i create the service I am not able to select the source. source only showing the sql .
![](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, 87%, 21%)' 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)
0 answers
SQL Server AOAG on multi subnet cluster using the same AD
Hi All, We have a SQL Server 3 node multi subnet cluster created having 2 node on production subnet and 1 disaster recovery (DR) node on another subnet but under the same domain/AD (One in Ohio and the other in NJ). What I know is that there should be…
![](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, 41%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Is it possible to upgrade a WID (windows internal database) 2014 to 2016 and also how to apply security updates.
Is it possible to upgrade a WID (windows internal database) 2014 to 2016 and also how to apply security updates. provide details about 'WID' and also how to install 'WID' please provide any documents using GUI.
asked 2025-03-01T12:14:44.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(201.6, 73%, 29%)' 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)
Anandhswarupp
125
Reputation points
accepted 2025-03-01T15:01:39.28+00:00
Anandhswarupp
125
Reputation points
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
119K
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
119K
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
119K
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
31,001
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,640
Reputation points Microsoft External Staff