SQL Server Migration Assistant

SSMA stopped working when we upgraded source database to MariaDB 10.11.x, how can we resolve this?

We are working on migrating from an Azure MariaDB to SQL Server on an Azure VM. The process was working until we upgraded MariaDB from 10.6.x to 10.11.x. Now we get an error stating, "Error occurred while collecting data". Additional error in…

SQL Server Migration Assistant for MySQL download page 404s

Hi, I was trying to download the SQL Server Migration Assistant for MySQL tool, but the link to download the latest version of the tool leads to a 404 page. See https://aka.ms/ssmaformysql, and this page was last updated in mid-late 2023 and has no…

Unable to install SQL server

TITLE: Connection Manager. The specified provider is not supported. Please choose different provider in connection manager. This error occurs when i try to configure ole db manager.

TITLE: Connection Manager The connection string is not valid. BUTTONS: OK this error comes up when i try to keep the provider as native ole db\microsoft ole db provider for sql server

How to fix Could not load file or assembly 'Ionic.Zip, Version=1.9.1.8, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c' or one of its dependencies erro

I am opening SSIS 2008 package on new Microsoft windows server 2019 datacenter ,for opening i am using sql server datatools 2019(VS2019) I added all the references of external DLL's but still getting System.IO.FileNotFoundException: Could not load file…

How to fix error Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host?

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host, I need to get data from microsoft project on line to moicrosoft SQL database

SSMA for Mysql Console Migration

The migration was successful in SSMA gui. But not on the console. It's a script I wrote <?xml version="1.0" encoding="utf-8"?> <ssma-script-file xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"…

Should I update statistics immediately after migrating to Azure SQL Server Managed Instance

I am migrating my 4TB database of Microsoft SQL Server 2016 2 node AG cluster from on-premises to Azure SQL Managed Instance. I am using Azure Data Studio to migrate through full backup and continuously applying log backup. This backup will be ongoing…

SSMS not installing

I have downloaded SSMS-Setup-ENU But when I double click to install nothing happens. Even when I try to run as an administrator nothing pops up

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…

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)?

SQL Server Integration Services Projects 2022 exe for VS2022 is not detecting VS2022 and hence unable to install it

When i install SQL Server Integration Services Projects 2022, it does not detect my installed VS 2022. Hence, unable to select any VS and install. I tried from different machines.. in some machines its getting detected, but disabled, doesn't allow me to…

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…

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…

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.

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.

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

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…

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…

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…