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
2 answers
Micorosft SQL Server migration assistant errors
Hi everybody, I'm trying to migrate a DB2 database to SQL Server using Microsoft SQL Server Migration assistant. After I run the report, I see some errors without any suggestion to fix them. Have you already used this tool? I have already read…
asked 2021-03-21T20:13:57.267+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, 96%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
emanuele gemelli
1
Reputation point
commented 2021-03-26T06:33:28.587+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
2 answers
BCP Not giving Desired output.
![80468-microsoftteams-image.png][1] [1]: /api/attachments/80468-microsoftteams-image.png?platform=QnA Hi all , Attached is the Output of a BCP Command . which is not the correct one . the marked line should be the first row .which is coming in middle of…
asked 2021-03-23T06:58:47.29+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, 74%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rakesh Dhar
96
Reputation points
commented 2021-03-26T06:15:56.423+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
1 answer
SQL Assessment(DMA)upload to Azure migrate is failing
We are trying to upload our SQL Assessment reports that we captured using DMA, The assessment were successfully, but the upload is failing with error attached. Trying with owner account, so there shouldnt be any permission issues.
asked 2021-03-17T18:37:44.66+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, 12%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Shashank
61
Reputation points
commented 2021-03-23T23:38:36.017+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, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
0 answers
AutoMigration : can't ALTER table or column name error
I have some issued in auto-migration approach which is given by M.S. Docs (link is below): https://video2.skills-academy.com/en-us/ef/core/managing-schemas/migrations/applying?tabs=dotnet-core-cli ( My Code ) var host =…
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
719 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,573 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.
507 questions
asked 2021-03-22T10:44:15.787+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, 34%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ1%3C/text%3E%3C/svg%3E)
JaySoni 1910
6
Reputation points
commented 2021-03-23T05:41:39.497+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, 7.000000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
Daniel Zhang-MSFT
9,621
Reputation points
1 answer
One of the answers was accepted by the question author.
Migrate from SQL Server 2014 Failover Cluster to 2019 Availability Group and rollback plan
Hi, we have a 2 node SQL Server 2014 failover cluster with 2 SQL Server instances and about 100 databases to be migrated to an availability Group 2019. What is the faster way to do that considering that we have one weekend for any instance? What's the…
asked 2021-03-18T15:49:15.163+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, 64%, 14%)' 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)
Cristian Mitan
21
Reputation points
commented 2021-03-22T10:00:18.79+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
1 answer
How to do AutoMigration in Entityframework core without using command (Using Programming only)
I use EF core in My project and I want migrate my context using Programming (not command) So I use these two concpets one by one 1. using (var serviceScope = app.ApplicationServices.GetRequiredService<IServiceScopeFactory>().CreateScope()) { …
asked 2021-03-18T12:43:17.46+00:00
JaySoni 1910
6
Reputation points
answered 2021-03-19T05:47:53.237+00:00
Michael Wang-MSFT
1,061
Reputation points
1 answer
Siebel Migration from Oracle Platform to SQL Server
We have Siebel 19.11 version on Oracle DB Version 12.2 on Linux OS. We would like to migrate this setup from Oracle to SQL Server with Windows Servers. Please provide any documentation specific to Siebel Migration from other DBs to SQL Server with OS…
asked 2021-03-12T06:55:51.587+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, 25%, 17%)' 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)
Srinivas Kammari
1
Reputation point
commented 2021-03-16T05:40:51.577+00:00
CarrinWu-MSFT
6,866
Reputation points
2 answers
One of the answers was accepted by the question author.
New SQL Server - license grace period
We are currently using SQL Server 2014 and want to stand up a new SQL Server 2019 instance on a new server (newer OS) to upgrade all our databases into. During the cutover time, both the 2014 and 2019 instances will coexist. Is there a grace period…
asked 2021-03-10T19:54:44.1+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(54.400000000000006, 53%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Darryl Schmidt
21
Reputation points
accepted 2021-03-12T14:33:23.75+00:00
Darryl Schmidt
21
Reputation points
0 answers
ssmafororacleconsole "losing" connection
Hello w, folks. Here I am again, with another question/problem. So, I developped a full ETL for our company to migrate some of our clients from Oracle to SQL Server. Long story short, I'm using SSMA only and exclusively to perform data copy across DBMS…
asked 2021-03-09T02:36:34.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(208, 36%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Leandro Martins de Lima
1
Reputation point
commented 2021-03-09T05:00:29.447+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, 65%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Alexander Ivanov
491
Reputation points
3 answers
Upgrading a SQL failover cluster - OS and SQL versions
Hi I need to upgrade a 2 node SQL failover cluster currently running Windows 2016 Std and SQL 2016 Std to Windows 2019 and SQL 2019 Std. I understand I can do a rolling upgrade by essentially upgrading the passive node first then failing over to it. …
asked 2021-03-03T16:01:51.733+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, 51%, 15%)' 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)
Algon
1
Reputation point
answered 2021-03-08T02:31:15.667+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(108.80000000000001, 46%, 20%)' 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)
AmeliaGu-MSFT
13,966
Reputation points Microsoft Vendor
1 answer
generate CreateTableOperation instance
I want to create new instance of CreateTableOperation class from my model via reflection or enything else. I have my model's name and I want to access CreateTableOperation instance with all ef standard attribute, to use it can anyone help me? my domain…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,573 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.
507 questions
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,579 questions
asked 2021-02-23T08:06:18.36+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, 48%, 39%)' 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)
Usa Pop
1
Reputation point
commented 2021-03-05T09:22:14.677+00:00
Daniel Zhang-MSFT
9,621
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL 2014 CLR Migration to SQL 2019
Hi, I am planning to migrate my CLR procedures from SQL 2014 to SQL 2019. Is SQL 2019 backward compatible to host CLR written for SQL 2014 ?
![](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, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
1 answer
Azure Manage Instance low performance than Azure SQl VM
Hi, We have a 16 Core Azure Manage Instance SQL, Queries are running very slow compared to Azure SQL VM. Example update statement of a table consists of 35 lakhs table is taking 12 Minutes whereas 8 Core SQL Vm is taking only just 0 seconds to complete…
asked 2021-02-23T03:21:08.953+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, 53%, 24%)' 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)
prashyuth
1
Reputation point
commented 2021-03-01T08:17:27.247+00:00
prmanhas-MSFT
17,901
Reputation points Microsoft Employee
4 answers
Power BI Report Server Report Embed Into Web Application Security Concern
We would like to use App-Owns-Data embedding model to use power bi report server report in our web application. From research, it seems like we can only use HTML iframe/object tags to set the URL of the embedded power bi report server report. Is there a…
![](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(89.60000000000001, 0%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
3 answers
Hyper V Migration Windows and SQL Cluster 2008 R2 ??
Hi, We have Hyper-V with SQL Server Cluster (Active-Passive). Windows cluster is 2008 R2 Enterprise Edition & SQL Server Cluster 2008 R2 Enterprise Edition. We want to migrate both active and passive server to new Rack Server having new hardware…
asked 2021-02-17T09:39:52.537+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(22.400000000000002, 7.000000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nikhil Desai
21
Reputation points
answered 2021-02-26T15:59:58.05+00:00
Alex Bykovskyi
1,841
Reputation points
2 answers
One of the answers was accepted by the question author.
Is there any downtime or services interruption if changing database from SIMPLE to FULL recovery mode?
I have two databases with around 100GB of size for each db, I am about to change the recovery mode from SIMPLE to FULL for always on availability group setup purposes. As there are users who still using this db, may I know if I just change the mode will…
asked 2021-02-18T01:58:58.243+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' %3EMW%3C/text%3E%3C/svg%3E)
Marcus Wong Theen Nam
1,111
Reputation points
answered 2021-02-25T15:51:07.007+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(246.4, 47%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Navneet Agarwal
1
Reputation point
1 answer
AlwaysOn AAG over SQL Server 2016 and SQL Server 2019?
Hi, is it possible to add a SQL Server 2019 to a SQL Server 2016 AlwaysOn AAG? Thanks for information Sven
asked 2021-02-18T15:29:56.317+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(294.40000000000003, 15%, 38%)' 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)
Worm, Sven
1
Reputation point
commented 2021-02-22T01:31:59.58+00:00
AmeliaGu-MSFT
13,966
Reputation points Microsoft Vendor
1 answer
sql server forums
Hi Expert, I am doing migration of sql server 2012 from server A to server B. There is no connectivity between server A to server B. so will be doing backup and restore . we have availability group name called group1,group2group3. so while migrating,…
asked 2021-02-14T02:07:14.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(54.400000000000006, 55.00000000000001%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Shri
21
Reputation points
commented 2021-02-16T08:20:17.883+00:00
AmeliaGu-MSFT
13,966
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to fix failed data type conversion error
I am inserting multiple columns from one table into another with MS SQL. I imported the data from Excel into a staging table and now inserting it into another table (to get around the float data type problem with excel) I updated that data types in the…
asked 2021-02-15T08:13:33.39+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(256, 36%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGJ%3C/text%3E%3C/svg%3E)
Greg Johnson
21
Reputation points
commented 2021-02-15T10:43:57.92+00:00
Greg Johnson
21
Reputation points
2 answers
Intento Insertar un Excel a una tabla SQL pero tengo problemas con "Microsoft.ACE.OLEDB.12.0"
Hola Tengo el siguiente problema , Cuando intento importar un documento Excel con filas vacías a cierta tabla SQL obtengo el siguiente error . Msg 7399, Level 16, State 1, Line 284 The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked…
asked 2021-02-12T22:22:46.98+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, 38%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Javier Gilvonio
1
Reputation point
commented 2021-02-15T09:48:07.687+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor