517 questions with SQL Server Migration Assistant tags

Sort by: Updated
0 answers

SSMA - Convert adhoc DML and DDL queries

Hello, Does Microsoft SQL Server Migration Assistant (SSMA) provide a way to convert an ah-doc DML or DDL query from DB2 z/OS syntax to MS SQL Server? By other means, I have an application that today has queries that execute on a DB2 z/OS and after the…

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 2024-07-24T17:03:00.64+00:00
Santo, Nuno 0 Reputation points
3 answers

Azure Data Studio - Azure SQL Migration extension thinks the Managed Instance is still in 'Creating' state.

In step 3 of the Azure SQL Migration where the user chooses the managed instance: Error: The managed instance 'managedinstance' is unavailable for migration because it is currently in the 'Creating' state. To continue, select an available managed…

Azure Database Migration service
Azure SQL Database
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
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions
asked 2023-02-28T11:28:45.1133333+00:00
Vlasopoulos V 10 Reputation points
answered 2024-07-23T21:33:54.5266667+00:00
Ronald Duenez Ortiz 0 Reputation points
1 answer

how to enable the Integration Services Catalogs node

I dont see the "Integration Services Catalogs"node option in my sql sever connection. how to enable this option in my server. i installed the developer edition and also have sql integration service

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 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 2024-07-22T02:44:00.19+00:00
Padmanaban U 0 Reputation points
answered 2024-07-22T06:06:27.76+00:00
ZoeHui-MSFT 35,546 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Data Migration Assistant, what actually happens during migration?

Migrating in-house SQL 2014 databases to a new, in-house SQL 2019 server. Reading all the documentation I don't see where it explains what happens to the source databases during the migration process. Are they backed up, then taken offline/detached and…

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 2022-04-12T21:57:43.443+00:00
Bill Clark 181 Reputation points
commented 2024-07-18T12:24:21.2366667+00:00
Alejandro Moreno Jr 0 Reputation points
2 answers

Use SQL Server 2022 License Key to Install SQL Server 2019

Hi, I have installed SQL Server 2019 on our cloud EC2 Windows server machine using the SQL Server Evaluation Edition with a 180-day free trial. We intend to purchase the SQL Server 2022 Standard Edition key. Can we use this key to activate the SQL Server…

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 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 2024-07-11T09:43:23.8833333+00:00
surya kannan 0 Reputation points
commented 2024-07-18T10:11:31.1033333+00:00
MikeyQiaoMSFT-0444 1,910 Reputation points
1 answer One of the answers was accepted by the question author.

I created a SSIS package to fetch data from an API to store in the Data Warehouse. But I am getting the runtime error in my script task. I even used try/catch to figure out the error, but nothing is working.

Additionally, I am using a variable 'Token' which I declared in ReadWriteVariables. The error - at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at…

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
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,640 questions
asked 2024-07-13T01:33:03.4633333+00:00
Manmohit Singh 20 Reputation points
accepted 2024-07-17T19:25:59.7033333+00:00
Manmohit Singh 20 Reputation points
2 answers One of the answers was accepted by the question author.

~|~ Delimiter. Has anyone seen ~|~ as a delimiter?

I received the text files from our vendor every morning. The file contains ~|~ as a delimiter. Has anyone ever seen this kind of delimiter and if so, how do you handle this kind of delimiter? I am using SSIS Package to import the text file into SQL…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 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 2024-07-16T18:46:12.36+00:00
Villa 206 Reputation points
commented 2024-07-17T10:57:13.18+00:00
Villa 206 Reputation points
3 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.…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,273 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 2024-03-01T11:15:38.9466667+00:00
Donatella Candelo 20 Reputation points
answered 2024-07-17T09:05:50.11+00:00
Donatella Candelo 20 Reputation points
2 answers One of the answers was accepted by the question author.

UNABLE TO DOWNLOAD SQL SERVER 2022 REPORTING SERVICES

Hi, I tried downloading the SQL SERVER 2022 REPORTING services but the download page is unable to reach don't know why is it temporary I'm trying download it from morning still same issue. Does anyone have any idea regarding thsi

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,875 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 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 2024-07-16T12:10:09.8666667+00:00
shajan reynold 20 Reputation points
edited a comment 2024-07-17T03:56:39.9933333+00:00
shajan reynold 20 Reputation points
1 answer

UNABLE TO DOWNLOAD SSMA for MySQL

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 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 2024-07-16T17:37:17.53+00:00
Angel Sergio Ramírez 0 Reputation points
commented 2024-07-17T01:45:41.8666667+00:00
MikeyQiaoMSFT-0444 1,910 Reputation points
1 answer One of the answers was accepted by the question author.

I can't use SSMA for Access because the DAO component is missing. What should I do?

I can't use SSMA for Access. When I installed it, I got an error message that the DAO component was missing. What should I do? (It seems as though the Microsoft download page is still not working.)

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
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
857 questions
asked 2024-07-16T20:16:08.54+00:00
jennifer neighbors 40 Reputation points
commented 2024-07-16T22:09:15.51+00:00
jennifer neighbors 40 Reputation points
1 answer One of the answers was accepted by the question author.

Where can I download SSMA for Access? The download page seems to be broken.

Where can I download SSMA for Access? The download page seems to be broken.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,347 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 2024-07-16T18:53:49.0466667+00:00
jennifer neighbors 40 Reputation points
accepted 2024-07-16T21:32:41.6433333+00:00
jennifer neighbors 40 Reputation points
1 answer One of the answers was accepted by the question author.

Workday and alternative

Hi, I have a table which needs to duplicate with weekday and alternative create table table3 ( col1 varchar(20) , col2 varchar(20)) expected results Insert into table1 values('catch', 'catch1') …

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 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 2024-07-16T04:34:21.7233333+00:00
Vineet S 425 Reputation points
accepted 2024-07-16T06:28:41.85+00:00
Vineet S 425 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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
341 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,624 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 2024-04-19T01:28:50.96+00:00
Elham Khalaji 0 Reputation points
commented 2024-07-04T11:11:44.27+00:00
Chandrasekar N 0 Reputation points
7 answers

How to resolve this "Microsoft.ReportingServices.WmiProvider.WMIProviderException:...." error?

I keep getting this error. Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,875 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-05-10T21:06:09.8+00:00
CharlieLor 551 Reputation points
commented 2024-07-04T03:49:54.77+00:00
Ryan 0 Reputation points
3 answers

Choose columns during migration when using SSMA

Is it possible to select specific columns when we migrate data from source to target in SSMA? Basically, I am getting error while migrating table data which contains computed columns in source side. So I was looking for either excluding the column…

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-02-09T19:57:55.623+00:00
Siddhesh Manjrekar 1 Reputation point
commented 2024-07-03T15:43:13.9766667+00:00
Pinky Rajan 0 Reputation points
2 answers

How do I back up a SQL database to Azure from Microsoft SQL Server Management Studio

I don't have access to the Azure portal to do it from that instance. I need to migrate the database to another server

Azure Database Migration service
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 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 2024-06-19T21:08:18.42+00:00
Sergio Sanchez 0 Reputation points
commented 2024-07-02T19:50:43.9666667+00:00
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
3 answers One of the answers was accepted by the question author.

Migrate from DB2 to Azure Database for PostgreSQL/MySQL/MariaDB

Hi, Is it possible to migrate a DB2 database to Azure database for PostgreSQL/MySQL or MariaDB? Thanks for the helping and documentation to do this process. Cordially, Albeiro Jiménez López

Azure Database Migration service
Azure Database for MariaDB
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
Azure Database for PostgreSQL
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 2023-11-02T16:25:02.83+00:00
Albeiro Jimenez Lopez 20 Reputation points
commented 2024-07-01T17:08:09.08+00:00
Uliana Philippova 0 Reputation points
4 answers

Data (of 15GB) from SQL 2000 to SQL 2012 via SQL 2008 - Express okay? Trial versions?

I'm trying to move a backup data (of 15gb) from SQL 2000 to SQL 2012. To do so, I must go thru SQL 2008 (or 2005), that is, A. Restore 2000-backup-file into 2008. B. Create 2008-backup-file. C. Restore 2008-backup-file into 2012. I've been looking for…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 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 2024-06-13T22:16:33.8266667+00:00
David 0 Reputation points
commented 2024-06-25T21:15:28.99+00:00
Erland Sommarskog 107K Reputation points
3 answers

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…

Azure Database for MariaDB
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,345 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 2024-06-06T16:36:10.5+00:00
Mark Daugherty 0 Reputation points
accepted 2024-06-25T20:35:05.2033333+00:00
Mark Daugherty 0 Reputation points