SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,367 questions
8 answers
Lixux shell scripts - convert isql istructions to sqlcmd istructions
Hi! We are migrating some shell scripts from unix to linux and we are bsolutely newby. Some scripts invoke slq scripts which contain instructions for operations on a syabase database that we are migrating to sql server database, so we are rewriting…
asked 2021-03-26T13:15:44.853+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(28.799999999999997, 33%, 12%)' 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)
Micheal Bolton
1
Reputation point
commented 2021-04-09T21:04:21.763+00:00
Erland Sommarskog
107.2K
Reputation points
2 answers
Why Restarting SQL Server fixed all the query performance issues and CPU decreased from 100% to 20%
Hello All, Just intrigued to get some insights on why all the query performance issue with my SQL Server 2016 SP2 CU5 (Enterprise) was fixed by just a SQL Server restart. Some background: We had a network degradation starting from 7:30 AM however…
asked 2021-04-06T21:16:38.233+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, 2%, 11%)' 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)
Ashif Shaikh
156
Reputation points
commented 2021-04-09T09:14:50.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(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,616
Reputation points
1 answer
One of the answers was accepted by the question author.
DMA connection error SQL Server
Hi, can you help me with this ? I 'm using Data Assistan Migration and when trying to connect to a SQL Server 2000 to start an Assessment I get the following error: Connection to the server failed. Line 2: Incorrect syntax near 'max'. …
asked 2021-04-06T22:10:20.397+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, 23%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Melin Guaringa, Charlie Stephano
21
Reputation points
commented 2021-04-07T22:36:07.763+00:00
Melin Guaringa, Charlie Stephano
21
Reputation points
2 answers
One of the answers was accepted by the question author.
In-place upgrade of SQL Failover Cluster Instance
I'm about to perform a in-place upgrade of existing SQL Failover Cluster Instance. I found this link from Microsoft but would like to confirm something. …
asked 2021-03-25T04:55:31.81+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
accepted 2021-04-05T02:53:34.59+00:00
Marcus Wong Theen Nam
1,111
Reputation points
0 answers
after upgrading sql server 2014 to 2019 Views become slow
after upgrading sql server 2014 to 2019 Views become slow but without view query run very fast
asked 2021-04-01T22:05:56.563+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, 94%, 16%)' 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)
sohel rana
1
Reputation point
commented 2021-04-02T02:45:54.697+00:00
CathyJi-MSFT
21,136
Reputation points Microsoft Vendor
2 answers
Adding Node to upgraded SQL 2019 Failovercluster
Hi, I've got an SQL Failovercluster running with Windows Server 2016 and SQL 2019. That Cluster was recently updated from SQL 2016 and worked without issues. But now I've noticed that when adding a new Node to an previously upgraded SQL Failover…
asked 2021-03-31T09:43:30.643+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(182.40000000000003, 0%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM1%3C/text%3E%3C/svg%3E)
Marcel-1650
26
Reputation points
answered 2021-04-01T10:14:20.63+00:00
Cris Zhan-MSFT
6,616
Reputation points
1 answer
Is it possible to change SQL and Windows Cluster Nodes IPs and hostnames
Hi, We have two VM having Windows 2012 STD. Windows cluster & SQL cluster (SQL 2012 STD) Active-Passive is created. VM is migrated to another location using VMware replication & migration method. After migration IP & hostname will be…
asked 2021-03-31T16:49:30.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(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-04-01T08:29:31.647+00:00
JiayaoZhu
3,911
Reputation points
2 answers
Microsoft SQL Server Database Consolidation
Good mornig to everyone. I am working to a hotels company as Information Technology Administrator. In company we have virtual servers and some of them running different versions of Microsoft SQL Server . Our plan is buy a new Physical Machine , install a…
asked 2021-03-27T10:42:01.507+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(259.20000000000005, 60%, 35%)' 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)
Michalis Tsimettas
1
Reputation point
commented 2021-04-01T01:49:06.897+00:00
CarrinWu-MSFT
6,866
Reputation points
4 answers
SSIS - DMA doesn't support migration assessment to SSIS in local SQL Server 2019
Hi, we will migrate from SQL Server 2008 R2 to SQL Server 2019 in near future, we already run DMA to analyze database, however DMA 5.2 doesn't support migration assessment type for intergration services (SSIS) when the destination server is a local…
asked 2021-03-03T20:22:35.61+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, 34%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Carlos Pereira
1
Reputation point
answered 2021-03-31T10:52:08.727+00:00
Carlos Pereira
1
Reputation point
0 answers
SQL Data Migration Assistant - Check Feature Parity unable to be checked.
Fellow SQL dbas. I am wanting to run the DMA to evaluate a db on SQL 2014 moving to SQL 2017. To install the new DMA version, it needs a newer .net framework than is on the box. I am not permitted to install that framework. I went to an older DMA…
asked 2021-03-30T14:44:33.597+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, 68%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Mark Gordon
906
Reputation points
asked 2021-03-30T14:44:33.597+00:00
Mark Gordon
906
Reputation points
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,136
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,136
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://learn.microsoft.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.
726 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,651 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.
517 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,136
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,971
Reputation points Microsoft Vendor