SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,201 questions
2 answers
Upgrade SQL Server 2019 (Standard Edition) to SQL Server 2022 (Standard Edition)
I want to upgrade my production SQL Server (2019 Standard Edition) version to SQL Server 2022(Standard Edition) which is hosted on the Azure virtual machine. There are 400-500 databases currently running on the SQL server 2019. So also want to migrate…
asked 2023-12-13T15:08:07.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(73.60000000000001, 84%, 17%)' 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)
kanav sharma
5
Reputation points
commented 2023-12-20T08:24:17.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(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
1 answer
Initialization error while migration assistance for MySQL
I am trying to migrate my MySQL database to MS SQL. I have already installed the ODBC driver and SSMA for MySQL. However I got an initialization error when trying to open SSMA. Cannot start because of an initialization error Try to restart the…
asked 2023-12-14T08:31:07.1233333+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, 61%, 35%)' 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)
Chua Camille
0
Reputation points
answered 2023-12-15T02:55:52.5266667+00:00
ZoeHui-MSFT
34,836
Reputation points
1 answer
Error deployment from SSIS to SQL Server
I tried to deploy project from ssis (visual studio) to SQL server and i got this error : TITLE: SQL Server Integration Services ------------------------------ A .NET Framework error occurred during execution of user-defined routine or aggregate…
asked 2023-12-13T13:03:32.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(198.4, 64%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIE%3C/text%3E%3C/svg%3E)
ikram elmbarki
0
Reputation points
answered 2023-12-14T05:28:36.6833333+00:00
ZoeHui-MSFT
34,836
Reputation points
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 2023-12-08T15:19:19.8833333+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, 18%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
COŞKUN SÜMER
0
Reputation points
1 answer
In Visual studio 2019, SSIS getting a connection issue for Odata connection.
Created a Odata connection with parameters like URL, Password, User name etc, and when I check the preview data, I'm able to see the data and when I run the package I'm getting an error like " Cannot acquire a managed connection from the run-time…
asked 2023-12-05T11:48:49.25+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, 14.000000000000002%, 34%)' 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)
Srinivas Ravi
0
Reputation points
commented 2023-12-08T12:02:19.1+00:00
Srinivas Ravi
0
Reputation points
1 answer
create an azure serverless database
Customer currently has much of the cloud environment in AWS and they will start to migrate to Azure
asked 2023-11-30T21:29:23.59+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, 66%, 31%)' 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)
Mario Scott (International Supplier)
0
Reputation points Microsoft Vendor
edited the question 2023-12-04T09:43:34.25+00:00
SadiqhAhmed-MSFT
40,291
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
migrate my MySQL database to SQL Server
Hello. I need to migrate my MySQL database to SQL Server. Where can I download SSMA for MySQL？ Is there any tutorial for me to refer to? Any help will be greatly appreciated.
![](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(169.60000000000002, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
2 answers
O2SS0013: EXECUTE IMMEDIATE statement was converted, but dynamic string was not converted. It must be converted manually.
Hi, I've checked common conversion errors for Oracle Database to SQL Server 2016 migration with SSMA (https://video2.skills-academy.com/en-us/sql/ssma/oracle/messages/o2ss0007?view=sql-server-ver16) however this error is missingO2SS0013, EXECUTE IMMEDIATE…
asked 2023-11-27T10:51:08.5966667+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(38.4, 84%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E6%3C/text%3E%3C/svg%3E)
65877627
0
Reputation points
answered 2023-11-27T22:17:17.48+00:00
Erland Sommarskog
105.8K
Reputation points MVP
2 answers
Oracle Connector For SSIS
We are migrating our SQL Server to 2021. We currently use the Antiunity driver which can no longer be used with latest version of SQL and SSIS. When we tried to use the "Microsoft Connector for Oracle" the source spooling is very slow and not…
asked 2023-11-22T15:43:58.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(57.599999999999994, 34%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Rajagopalan, Ganesh : Functions Technology
20
Reputation points
answered 2023-11-23T08:21:27.1166667+00:00
ZoeHui-MSFT
34,836
Reputation points
1 answer
MSB1009: Project file does not exist, Switch: database
My web application is not showing my images because there is an issue with my database I then fixed this as the issue was Caps. When I tried to run 'dotnet ef database update' this is the error I received: Found some duplications and fixed them but the…
asked 2023-10-30T14:23:19.6166667+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(147.20000000000002, 30%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOM%3C/text%3E%3C/svg%3E)
Oratile Motaung
0
Reputation points
commented 2023-11-20T08:49:34.67+00:00
Oratile Motaung
0
Reputation points
4 answers
One of the answers was accepted by the question author.
Migrating from ADF to SSIS
I have been using the Azure Data Factory as the ETL tool but I would like to downgrade/migrate to the on-prem SSIS due to business decision. Is there a way to go about this except re-writing the pipelines? Maybe a lift and shift solution? All the…
asked 2023-11-13T13:36:11.74+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, 56.00000000000001%, 36%)' 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)
Sinah Molepo
20
Reputation points
answered 2023-11-16T10:29:05.51+00:00
Sinah Molepo
20
Reputation points
7 answers
One of the answers was accepted by the question author.
SQL Server 2019 Upgrade Problem
I am attempting to upgrade from SQL Express 2014R2 to SQL 2019 Standard and have run into an issue :: Database Engine Services -FAILED :: SQL Client Connectivity SDK - FAILED We have run out of room with the Database and Express ;;; Thanks in…
asked 2022-05-15T12:54:27.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(150.4, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Victor RGV
26
Reputation points
answered 2023-11-15T19:32:07.8366667+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, 95%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Damian Hatcher
6
Reputation points
1 answer
raw file source task is unique in SSIS due to which properties associated with it
raw file source task is unique in SSIS due to which properties associated with it. ( choose one or more options, which suitable) a. it is aware of the sort order of the data in the source file b. it doesn't create a connection manager when configured c.…
asked 2023-11-14T15:18:17.7366667+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, 56.00000000000001%, 15%)' 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)
Srinivas, Ramidi (Cognizant)
0
Reputation points
answered 2023-11-15T02:22:24.8666667+00:00
ZoeHui-MSFT
34,836
Reputation points
1 answer
SSMA for Oracle Crash at Data Migration
Hi, I am working for Oracle to SQL Server Migration through SSMA. i migrated tables structure to sql server. it has around 4800 Tables. it takes lot of time to create structure as well as analyse metadata. Migrating data... Analyzing…
asked 2023-11-11T17:39:16.4966667+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, 60%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Madhan Kumar
0
Reputation points
answered 2023-11-13T06:10:01.1033333+00:00
PercyTang-MSFT
12,426
Reputation points Microsoft Vendor
2 answers
my project team is looking to automatically print food orders from SSIS ...
and it does not provide a method to print (it create for data migration, data transformation, and integrations). Is it possible to send the PDF files to be printed in an automated fashion, as the team was unable to find any APIs for PaperCut that would…
asked 2023-10-31T02:58:49.3666667+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, 31%, 35%)' 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)
Cindy Chapman
0
Reputation points
answered 2023-11-06T11:33:53.58+00:00
Alan Morris
1,161
Reputation points
2 answers
One of the answers was accepted by the question author.
PostgreSQL single server to flexible server migration error - permission denied for admin user
When I am doing migration of 3 databses(schemas), between single server and flexible server postgresql I am getting error shown below Data migration could not be started for one or more of the DBSets. Error details: PGv2RestoreError: PG Restore…
asked 2022-11-04T16:03:06.997+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(160, 83%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nowakowski Krzysztof
21
Reputation points
answered 2023-11-03T13:45:31.37+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, 39%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
devopsfj
196
Reputation points
2 answers
How to download older version of SQL Server Migration Assistant for DB2?
We are facing issues with SSMA for DB2 version 9.3 and unfortunately thats the only version that is currently available for download. The tables from DB2 (for i) in the metadata explorer are not showing any column information. We used SSMA for DB2 v9.2…
asked 2023-05-04T12:50:46.5433333+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, 3%, 27%)' 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)
Shaik, Ashraf (Contractor)
5
Reputation points
commented 2023-11-03T13:10:36.19+00:00
SandipKhandelwal-MSFT
96
Reputation points Microsoft Employee
1 answer
SQL audit file Rollover is not working
HI all. SQL audit file Rollover is not working I try. The SQL Service account has full permissions to the folder, and I Try disable/enable the audit session to see if it removes the file. and it works for some days. Please give me some advice.
asked 2023-10-17T04:53:52.17+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, 60%, 37%)' 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)
Uddandam Prasanth (QUANTUM LEAP CONSULTING PRIVAT)
0
Reputation points Microsoft Vendor
answered 2023-10-30T02:44:42.73+00:00
Vahid Ghafarpour
20,480
Reputation points
1 answer
Issue with SSMA for DB2 not displaying table fields and formats
I successfully connected SSMA for DB2 to IBM i DB2 and can see schema names and tables in the DB2 Metadata Explorer. However, clicking on a table does not show the table column/field names and formats under the table tab on the right side. Why is this…
asked 2023-09-08T18:11:33.38+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, 21%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMO%3C/text%3E%3C/svg%3E)
Marshall Owen
10
Reputation points
commented 2023-10-27T06:48:07.2933333+00:00
SandipKhandelwal-MSFT
96
Reputation points Microsoft Employee
0 answers
SSMAforSybaseConsole.EXE causes FileIsLockedException
Executing more than 1 or 2 sessions using SSMAforSybaseConsole.EXE in Powershell / cmd causes FileIsLockedException. How to resolve this ? Unhandled Exception: Microsoft.SSMA.Framework.Generic.Factories.Utils.FileIOUtils+FileIsLockedException: The…
asked 2023-10-27T05:53:31.17+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, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Maheen, Aziq Ahamed
0
Reputation points
asked 2023-10-27T05:53:31.17+00:00
Maheen, Aziq Ahamed
0
Reputation points