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…
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…
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…
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 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…
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…
~|~ 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…
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.…
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
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.)
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.
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') …
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
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…
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…
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
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
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…
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…