SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,706 questions
1 answer
Use SSMA for DB2 to Migrate AIX DB2 11.5.9 to SQL Server 2019
Is it possible to use the SSMA tool to migrate an AIX DB2 (Big endian) to Windows SQL Server 2019 (little endian)?
asked 2024-04-09T20:16:55.67+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, 16%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Robert Carter
0
Reputation points
commented 2024-04-25T02:54:55.83+00:00
LucyChen-MSFT
885
Reputation points Microsoft Vendor
4 answers
Is it Possible or is there a way to use the database you have been working on the developer option for production?
Can I migrate the database I made on the developer version to the express version or is there a way to use the database you created using the developer version for production purposes, say if you can transfer my database to the express version or pay for…
asked 2024-04-23T12:11:55.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(156.8, 6%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Betselot Getahun
0
Reputation points
answered 2024-04-24T10:16:39.1466667+00:00
MikeyQiao-MSFT
485
Reputation points Microsoft Vendor
0 answers
Unable to start Microsoft SQL Server Migration Assistant for Access
I have installed SQL Server Migration Assistant for Access, but it will not start up. When I launch the program, it displays the splash screen and as it is displaying the message "Configuring Telemetry...", the program throws an exception. How…
asked 2024-04-24T04:58:52.4633333+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, 42%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Alister Oram
0
Reputation points
asked 2024-04-24T04:58:52.4633333+00:00
Alister Oram
0
Reputation points
2 answers
One of the answers was accepted by the question author.
best approach to migrating a table from system to another
I have a test system where we update entries on a table for cross refence purpose and was wondering the best approach for this.
asked 2024-04-19T19:52:02.5533333+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, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
40
Reputation points
accepted 2024-04-22T13:09:20.73+00:00
Jonathan Brotto
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Could you please suggest the list of software needed to register and use a custom component in data tools tool box using VS2019 in x64
Issue Description: Facing issue in setting up and running SSIS in debug mode in VS2015 that can recognize 64-Bit C# custom components in Data Tools Tool box. Created MyCustomComponent.dll by referencing below dlls. Took the dlls from…
asked 2024-04-08T12:34:26.1366667+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(316.8, 78%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
SAILANATHAN Balaji
20
Reputation points
accepted 2024-04-22T05:09:47.6733333+00:00
SAILANATHAN Balaji
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Best way to learn SSIS
I got a new role where we will use SSIS to migrate data from test system to production. What would be the best way to learn SSIS as I have worked with T-SQL and SSMS. It will be on premise 2019 edition.
asked 2024-04-19T19:35:40.58+00:00
Jonathan Brotto
40
Reputation points
accepted 2024-04-19T20:54:43.45+00:00
Jonathan Brotto
40
Reputation points
2 answers
where can I find Microsoft.ACE.OLEDB.12.0 Provider 64-bit
hello, We need the driver "Microsoft.ACE.OLEDB.12.0 Provider 64-bit", but it is no longer available! Could you provide me with a download link? Regards
asked 2024-04-19T01:28:50.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(192, 68%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
Elham Khalaji
0
Reputation points
answered 2024-04-19T05:55:04.49+00:00
Olaf Helper
40,741
Reputation points
1 answer
One of the answers was accepted by the question author.
Lift Azure SSIS to adf , Can we mount blob storage in SSIS integration Runtime
In SSIS we are reading multiple files from D:(local drive) In azure all the file are available in blob Is it possible to mount blob storage with ssis integration run time? so that with minimal changes we can do lift and shift or else we need to work…
asked 2024-04-17T09:51:44.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(35.2, 70%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Thangamuthu, Vignesh
20
Reputation points
commented 2024-04-17T13:52:34.4466667+00:00
Amira Bedhiafi
15,216
Reputation points
0 answers
SS Migration Assistant (SSMA) for Oracle: BLOBS larger than 2GB and SSMA Support for FILESTREAM columns
Hi. I'm trying to determine if the SSMA utility for Oracle to SQL Server supports the migration of BLOB data larger than 2GB in size. I tried running a test SSMA run, and during the Convert step, it looks like the target SQL Server table creation…
![](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(163.2, 65%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%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(208, 14.000000000000002%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
1 answer
SSIS package running fine in visual studio but when trying to run same package its failing.
Dear Team, I want to do simple copy activity using Data flow task in SSIS package, in which my source is a old database using visual fox bro and tables are saved as dbf files . I am using OLE DB connector for visual fox pro to get data from source dbf…
asked 2024-04-03T06:27:57.8566667+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, 88%, 14%)' 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)
Vikash Kamat
0
Reputation points
commented 2024-04-09T10:26:59.8766667+00:00
Vikash Kamat
0
Reputation points
2 answers
ORA-01017 Error in SSMA for Oracle
I am trying to leverage SSMA for Oracle and am running to an ORA-01017: Invalid username/password; logon denied error when trying to connect to the Oracle dB. A UDL connection to the Oracle dB from the same machine and with the same credentials works…
asked 2023-10-23T19:10:20.1066667+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(172.8, 47%, 26%)' 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)
Keith Steflik
0
Reputation points
answered 2024-04-03T09:21:48.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(313.6, 70%, 40%)' 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)
Mihocka, Martin
0
Reputation points
1 answer
SSIS Send Mail Task Fails on Out of office
I have a simple Send Mail Task that sends an email to a list of dynamic users. If one of those users has "out of office" set, the SSIS flow fails. The next day, when it sends again, it works, because "out of office" doesnt respond…
asked 2024-03-25T13:11:29.8966667+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, 30%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mark Lewin
0
Reputation points
commented 2024-03-28T13:35:58.5233333+00:00
Mark Lewin
0
Reputation points
1 answer
Connection to ACCESS database fails with exception: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Connection to ACCESS database fails with exception: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine How can i solve this problem ? Please guide me
asked 2024-03-27T05:21:59.99+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(291.2, 54%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHT%3C/text%3E%3C/svg%3E)
himanshu tripathi
0
Reputation points
answered 2024-03-27T13:59:10.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(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
24,946
Reputation points
3 answers
unable to uninstall sql server 2019
while uninstalling sql server the below error is popping up kindly help
asked 2023-01-22T06:48:48.7666667+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, 88%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Madhusudhan
0
Reputation points
commented 2024-03-26T14:06:35.2366667+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, 62%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Leo R
0
Reputation points
2 answers
Struggling with SSIS lookup date key transformation
How do i fix the below error, i have confirmed a million times that the data type is the same. The date formats are different though. Could that be the problem
asked 2024-03-21T12:09:24.4733333+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(86.4, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Susan Gatura
0
Reputation points
answered 2024-03-22T01:31:06.7566667+00:00
ZoeHui-MSFT
32,736
Reputation points
1 answer
Transaction Log is full due to 'ACTIVE_TRANSACTION'
Hi While migrating data from a Sybase SQL server to MS SQL Server uusing SSMA for Sybase v9.4 I found about 40 errors showing: Errors: The transaction log for database 'MyDatabase' is full due to 'ACTIVE_TRANSACTION'. In result I believe the migration…
asked 2024-03-19T17:27:24.1966667+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
answered 2024-03-19T19:24:18.6266667+00:00
Olaf Helper
40,741
Reputation points
2 answers
Not able to add sql server to west europe location, while my azure portal students account is based in the Netherlands.
I'm not able to create a sql server in west europe, but i am able to create servers in other regions using my azure for students account. Using other regions costs too much for data transfer between regions. Would anyone know the solution or why i can't…
asked 2024-03-10T12:29:30.1366667+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(70.4, 69%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Rens van der Burg (1034400)
5
Reputation points
answered 2024-03-15T08:02:58.4133333+00:00
Mert Cakir
0
Reputation points
1 answer
Issues with SQL failover cluster on windows 2016 migration
Hi, We are in the process of migrating our windows server 2012 servers to 2019 and we are using failover cluster to maintain our SQL always on. As we know , it's only possible to get to 2019 through windows 2016 for compatibility reasons and i'm familiar…
asked 2024-03-12T12:52:37.3433333+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, 45%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYN%3C/text%3E%3C/svg%3E)
Yishai Neeman
20
Reputation points
answered 2024-03-14T12:31:09.75+00:00
Yishai Neeman
20
Reputation points
2 answers
One of the answers was accepted by the question author.
How upload a file from my pc in sharepoint online
Hi, I create a ssis that produce a file xls test.xlsx, saved in a local directory of my pc. Then I would like to copy this file in a sharepoint online es.…
asked 2024-03-01T11:15:38.9466667+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, 0%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Donatella Candelo
20
Reputation points
answered 2024-03-14T09:20:01.5533333+00:00
Donatella Candelo
20
Reputation points
2 answers
PC OS clean install. How to transfer SQL license?
Have this SQL server: Microsoft SQL Server 2017 Enterprise Edition: Core-based Licensing (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 17763: ) And trying to update windows to windows 11. Is there a way to transfer the SQL license? Thanks.
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,746 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,706 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.
494 questions
asked 2024-03-12T18:44:41.35+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, 92%, 27%)' 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)
Alec Sim
0
Reputation points
answered 2024-03-13T02:54:52.0533333+00:00
CosmogHong-MSFT
22,941
Reputation points Microsoft Vendor