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
1 answer
One of the answers was accepted by the question author.
How Do I Migrate a Managed Instance of SQL Server to Another Cloud?
How Do I Migrate a SQL Server Managed Instance to Another Cloud?
![](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, 83%, 13%)' 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)
2 answers
How to fix data convertion error from string value to int in ssis
Currently, I am working on a task where I am using the "SSIS Integration Toolkit for Microsoft Dynamics 365" to fetch data from online dynamic CRM source and populate this to on prem CRM database(just a copy activity). I am using dynamic crm…
asked 2023-09-20T17:25:25.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(201.6, 1%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA5%3C/text%3E%3C/svg%3E)
AvijitSwarnakar-5337
0
Reputation points
edited the question 2023-10-18T07:52:29.43+00:00
AvijitSwarnakar-5337
0
Reputation points
2 answers
How to fix power function issue while changing db compatibility level change
We are using sql server 2019 server with db 110 compatability. Currently we are changing the DB compatability level from 110 to 150.After changing the compatability level to 150 , we have noticed the breakage there in the power of function and its…
asked 2023-09-11T07:43:28.2133333+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(102.4, 44%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
narmatha pitchaimani
0
Reputation points
edited the question 2023-10-16T15:57:34.4133333+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
0 answers
SSMA for Sybase - Schema conversion error
HI, I am using SSMA for Sybase to test migration from SAP ASE 16 to MS SQL Server 2019 on Linux (Microsoft SQL Server 2019 (RTM-CU16-GDR) (KB5014353) - 15.0.4236.7 (X64) May 29 2022 15:55:47 Copyright (C) 2019 Microsoft Corporation Enterprise…
asked 2023-10-12T18:30:38.78+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
commented 2023-10-12T18:32:33.9733333+00:00
Tahir Khalil
41
Reputation points
1 answer
SQL Server Import and Export Wizard: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)
I wish to import data to a SQL Server from an Excel spreadsheet via SQL Server Management Studio Management Studio (SSMS) 2019's Import Data feature. I have: Microsoft SQL Server 2022 Microsoft SQL Server Tools 19 SQL Server Management Studio…
asked 2023-10-11T01:45:48.0633333+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(198.4, 92%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEE%3C/text%3E%3C/svg%3E)
Eric Elftmann
5
Reputation points
answered 2023-10-11T02:52:22.3233333+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(230.39999999999998, 89%, 32%)' 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)
AniyaTang-MSFT
12,416
Reputation points Microsoft Vendor
2 answers
Issues while connecting the oracle to the SSMA
Hi, I am facing the below issue while connecting to the oracle through SSMA. What could be the reason ? I am able to connect to the SSMA with the oracle sql developer perfectly and i feel the oracle user connected has the admin rights
asked 2023-10-05T06:20:26.0766667+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, 68%, 10%)' 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)
Rahul
251
Reputation points
answered 2023-10-06T01:44:42.7033333+00:00
PercyTang-MSFT
12,426
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Query on SQL services
Hi I am running Microsoft SQL 2016(SP3-GDR)(KB5021129) v13.0.6430.49 (X64) on Windows Server 2012R2. The VM is in Azure.I want to upgrade the VM to Windows Server 2019. Will this SQL version support Windows Server 2019.Are there any steps which needs to…
asked 2023-09-28T05:05:52.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(137.6, 72%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERF%3C/text%3E%3C/svg%3E)
Rising Flight
4,196
Reputation points
accepted 2023-10-03T11:49:19.58+00:00
Rising Flight
4,196
Reputation points
1 answer
One of the answers was accepted by the question author.
Can I rerun Data Migration Assistant?
I have a Production server and a new one to take over from it. I ran Data Migration Assistant on the new server and everything looks fine. Can I simply re-run it again later to get any data changes at the time I wish to swap the servers?
asked 2023-10-02T19:16:50.2433333+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, 74%, 10%)' 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)
Rowe, Scott M. DDS West Columbia
61
Reputation points
commented 2023-10-03T11:45:38.2566667+00:00
Rowe, Scott M. DDS West Columbia
61
Reputation points
1 answer
How can i move data from sql server to snowflake using ssis.. and what all things to be considered and needed to perform this .
Hi Team, I am new to MSBI and snowflake, Please suggest me process. How can i move data from sql server to snowflake using ssis.. and what all things to be considered and needed to perform this .
asked 2023-09-29T01:52:41.6933333+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, 34%, 32%)' 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)
Mounika, Durgam
1
Reputation point
commented 2023-10-02T09:27:11.96+00:00
AniyaTang-MSFT
12,416
Reputation points Microsoft Vendor
0 answers
Query related to SQL services
Hi All I am running Microsoft SQL 2016(SP3-GDR)(KB5021129) v13.0.6430.49 (X64) on Windows Server 2012R2. This VM is running on Azure.I want to upgrade the VM to Windows Server 2019. Will this SQL version support Windows Server 2019. Are there any steps…
asked 2023-09-28T05:03:27.1033333+00:00
Rising Flight
4,196
Reputation points
commented 2023-09-28T05:15:17.2966667+00:00
Olaf Helper
42,841
Reputation points
1 answer
What are the steps to check before we migrate Tables from sql server to snowflake using ssis and what is the process to migrate ??
What are the steps to check before we migrate Tables from sql server to snowflake using ssis and what is the process to migrate ??
asked 2023-09-26T22:34:15.4733333+00:00
Mounika, Durgam
1
Reputation point
edited the question 2023-09-27T07:03:34.9433333+00:00
Hung-Chun Yu
976
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to view Azure Data Factory SSIS Cluster utilization
Hi , We are running SSIS Integration Runtime in our Data Factory instance to execute our SSIS workloads. For the work loads we have deployed in production I believe the the SSIS Cluster is over spec'ed, we have 2 nodes in a cluster executing SSIS…
asked 2023-09-25T10:44:52.34+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, 85%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Chris Courtney
20
Reputation points
edited a comment 2023-09-26T09:42:03.2233333+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, 61%, 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)
phemanth
8,165
Reputation points Microsoft Vendor
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)
2 answers
One of the answers was accepted by the question author.
Cases assigned to me
When we uninstall an unused SQL Server from our environment, is there any technical impact on the server side?
asked 2023-09-19T07:59:23.8866667+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, 82%, 15%)' 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)
Rao, Mayank
20
Reputation points
accepted 2023-09-19T16:15:04.33+00:00
Rao, Mayank
20
Reputation points
3 answers
alternative to store procedure
Hi Expert, do we have any alternative to store procedure while running merge statement where we can use exec or run like exec sp_name can we use view instead of any table to something else Regards
asked 2023-09-14T13:26:11.2666667+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, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shambhu Rai
1,406
Reputation points
edited a comment 2023-09-15T10:25:28.9566667+00:00
Shambhu Rai
1,406
Reputation points
1 answer
'Dynamics CRM Destination' does not have a value for the ID property
While using the KingwaySoft tool for data migration from Dynamics CRM to another CRM table, I encountered an error message stating: 'The 'Dynamics CRM Destination.Connections[DynamicsCRM]' in the connection manager collection, Connections, of 'Dynamics…
asked 2023-09-05T06:11:13.4166667+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(166.4, 8%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Amit Giri
0
Reputation points
edited the question 2023-09-06T03:16:32.98+00:00
ZoeHui-MSFT
34,836
Reputation points
3 answers
How to make ssis package to read data from db2 and insert to SQL server ?
I have two servers one server have sql server database and another server have db2 database I need to read data from db2 database on server A then after read it insert it into sql server database that exist on server B I use sql server 2017 so can…
asked 2023-08-10T07:51:22.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(9.6, 96%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ahmed Abd El Aziz
315
Reputation points
edited the question 2023-08-31T05:07:16.21+00:00
Jack J Jun
24,491
Reputation points Microsoft Vendor
1 answer
Copy db from dev to UAT env
hi, I need to copy complete db from dev to UAT environment, it is azure sql db. UAT server is freshly created and setup. How to move db from dev to UAT? what are the different approaches and best to do this? what important do's and donts?
asked 2023-08-30T06:17:08.6466667+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, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Santhi Dhanuskodi
205
Reputation points
answered 2023-08-30T08:32:57.31+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, 4%, 31%)' 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)
ShaktiSingh-MSFT
14,281
Reputation points Microsoft Employee
4 answers
How to execute Snowflake Stored Procedure with multiple parameters via Microsoft SSRS Report Builder3 2012 using SSRS expression in single statement.
Background : We have SSRS reports, which we used to run using T-SQL stored procedure from SSRS against SQL server, As per the new requirement, we now will be using Snowflake Stored Procedure (In Java script) replacing T-SQL stored procedure. Problem…
asked 2021-07-30T07:58:30.277+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, 92%, 37%)' 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)
Anuj1 Singh
1
Reputation point
answered 2023-08-30T05:17:56.4666667+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, 62%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
CourseDrill Technologies
0
Reputation points
1 answer
Cannot start because of an initialization error - Microsoft SQL Server Migration Assistant for Oracle
Trying to Open SQL Server Migration Assistant for Oracle and I am getting Initialization Error Error: Cannot start because of an initialization error Try to restart the application. If this problem remains, contact support group (please provide a log…
asked 2023-04-12T15:57:53.7566667+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(99.2, 47%, 19%)' 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)
VinMadan
0
Reputation points
commented 2023-08-27T15:56:52.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(268.8, 50%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Ajit Choudhary
0
Reputation points