SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,375 questions
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,361
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
985
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
1 answer
linked services using integration runtime
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'JOEL\SQLEXPRESS03', Database: 'AdventureWorksLT2022', User: 'joel4'. Check the linked service configuration is correct, and make sure the SQL Database firewall…
asked 2024-12-02T04:46:57.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(281.6, 56.00000000000001%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETJ%3C/text%3E%3C/svg%3E)
Thierry Joel Meli Tchinda
0
Reputation points
answered 2024-12-09T04:47:52.72+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
16,171
Reputation points
2 answers
Possibity of upgrade and migration from SQL 2014 to SQL 2022
HI Team, I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way. Kind regards,
asked 2024-11-15T08:49:17.6066667+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, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tarik sendro
0
Reputation points
commented 2024-11-22T14:37:11.7166667+00:00
Tarik sendro
0
Reputation points
1 answer
Upload to Azure Migrate - Error AADSTS16000
I am using the latest version of Data Migration Assistant. Once I finish the assessment of a local SQL Server instance and try to upload the assessment to Azure migrate, I get this error after signing in to my Azure account. I can log into the portal and…
asked 2024-11-15T06:26:16.32+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(112.00000000000001, 89%, 20%)' 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)
agam chauhan
0
Reputation points
answered 2024-11-15T06:53:31.8266667+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(217.60000000000002, 24%, 31%)' 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)
Abiola Akinbade
22,625
Reputation points
5 answers
SSIS not inserting all rows from ODBC (oracle) to SQL server 2019
I have an issue with migration to SQL server 2019. My Source is Oracle and my Destination is Microsoft SQL Server 2019. My package consists of a simple Data Load task; ODBC Source Connection(oracle)/ and OLE DB Destination connection(2019 SQL…
asked 2021-04-05T06:10:44.777+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(44.800000000000004, 81%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kumar, A. be
16
Reputation points
commented 2024-11-14T06:34:08.11+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, 23%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Maxwell Hartono
0
Reputation points
1 answer
One of the answers was accepted by the question author.
How to migrate large Sybase database using SSMA for Sybase
We are on Sybase/SAP ASE database of various sizes the larges one contains about 1TB of data. We are testing the migration it to on-premise MS SQL Server 2022 Linux, using SSMA for Sybase. Our concern is to move the full data during the downtime which…
asked 2024-11-04T17:31:34.44+00:00
Tahir Khalil
61
Reputation points
accepted 2024-11-05T12:25:11.78+00:00
Tahir Khalil
61
Reputation points
1 answer
DMA tool compliance
Hi Team, We are planning to do some assessments using DMA but i am unable to find any good document for compliance issues for DMA. Can you please help to find the DMA compliance. How to make sure DMA is compliance and safe tool for assessments.
asked 2024-11-01T06:26:36.4866667+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, 52%, 30%)' 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)
Sanjeev Reddy
30
Reputation points
commented 2024-11-04T06:23:46.93+00:00
Sanjeev Reddy
30
Reputation points
2 answers
Error at oled destination
TITLE: Package Validation Error Package Validation Error ADDITIONAL INFORMATION: Error at Package: The connection "{ED0A6B78-CF34-429E-86CF-4E157EE8CD5E}" is not found. This error is thrown by Connections collection when the specific…
asked 2024-10-23T17:40:08.2066667+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, 34%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESZ%3C/text%3E%3C/svg%3E)
Siqi Zhao
0
Reputation points
edited an answer 2024-10-27T01:57:45.6966667+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, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
26,371
Reputation points
0 answers
Azure Managed Instance Migration offline mode. Cannot find full back up error
I am trying to my migrate my on-prm sql server to SQL managed instance via Azure Data Studio Managed instance. I am using the offline mode to migrate the server and my back up files are saved in blob starage account. When i initate the migration i get an…
asked 2024-08-02T18:55:23.06+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(105.60000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hossain, Shakir
21
Reputation points
commented 2024-10-23T22:03:30.4533333+00:00
Oury Ba-MSFT
20,176
Reputation points Microsoft Employee
2 answers
we are trying to migrate the database from 2019 express edition to 2017 enterprise edition , pls suggest which POA is best , how we will do this activity without any error .
we are trying to migrate the database from 2019 express edition to 2017 enterprise edition , pls suggest which POA is best , how we will do this activity with any error . we will plan for migration through data tier application but we have one issue…
asked 2024-10-17T09:40:46.94+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(6.4, 44%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Srinivas Naraipeddi
40
Reputation points
commented 2024-10-22T21:36:22.71+00:00
Erland Sommarskog
116K
Reputation points MVP