cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Modernization Best Practices and Reusable Assets Blog
Options
797

Data Archiving Strategies for SQL Server

Mitch van Huuksloot on May 17 2022 11:59 AM
As databases grow, keeping them performing well becomes increasingly more difficult. Often pruning data that is no longe...
2,155

Mainframe files transfer to Azure Data Platform using SFTP

Sandip_Khandelwal on May 06 2022 02:05 PM
This article provides information about how to perform secured file transfer from Mainframe to Azure Data Lake Storage d...
1,180

Database Migration / Reverse Migration between Azure SQL (DB/MI) and SQL Server using SmartBulkCopy

DesFitz on Mar 28 2022 08:57 AM
The purpose of this blog post is to accelerate and automate database migrations between different SQL Server Source and ...
2,275

Database Comparison Tool

Mitch van Huuksloot on Mar 07 2022 12:59 PM
Migrating data between databases often requires verification. This tool allows a flexible, high performance way of compa...
1,609

Database migrations to Azure SQL Managed Instance - Restore with Full and Differential backups

ashricky89 on Feb 18 2022 04:03 AM
This blog will guide organizations to help accelerate migrations from on-premises, IaaS and/or relevant SQL Server imple...
1,765

SQL Server Replication as a tool to migrate very large databases

Sonali_Solanki on Feb 18 2022 02:06 AM
SQL Replication can be used as a viable tool for some migration scenarios, especially when there is a need to move trans...
1,826

Migrating Mainframe RACF user identities to Azure Active Directory Users

Ramanath_Nayak on Feb 17 2022 11:30 AM
RACF[Resource Access Control Facility] is one of the main security components which does authorization and authenticatio...
716

Oracle Estate Migration to SQL Server Scripting Tools

Mitch van Huuksloot on Feb 09 2022 08:06 AM
Collecting information to perform migration assessments for many servers is a painful manual effort. To alleviate some o...
1,534

SQL Server Regular Expressions Library Sample

Mitch van Huuksloot on Feb 03 2022 11:00 AM
When migrating from another database platform to SQL Server, the lack of regular expressions support can sometimes be a ...
918

PowerShell script to help migrate from DTU to vCore model of Azure SQL DB.

Mitch van Huuksloot on Feb 03 2022 10:44 AM
If you already own SQL Server licenses, there are cost advantages of switching from the DTU model to vCore model in the ...
2,317

Mainframe Data Modernization to Azure

Ramanath_Nayak on Jan 27 2022 03:30 PM
Data is a critical part in all Businesses. When there is modernization involved, transfer or migration of data from sour...
1,631

Using Heterogeneous Linked Servers from Azure SQL MI

Mitch van Huuksloot on Jan 27 2022 03:25 PM
Today, Azure SQL Managed Instance has the ability to create linked servers, but only to SQL Server targets. Although ext...
3,334

Copy files from Mainframe to Azure Data Platform using ADF FTP Connector

Sandip_Khandelwal on Jan 12 2022 01:08 PM
Mainframe to Azure Storage File Transfer using Azure Data Factory. 
3,231

Azure SQL Managed Instance – Sync Agent Jobs and Logins in Failover Groups

narenan on Oct 21 2021 01:09 PM
In an Azure SQL Managed Instance setup with Failover Group, the schema, data, and database-level users will always be sy...

Latest Comments

amethyst
in Copy files from Mainframe to Azure Data Platform using ADF FTP Connector on May 17 2022 04:49 PM
@Fredy_Rivera SFTP access pattern for Mainframe is posted here Mainframe SFTP to Azure (microsoft.com)
0 Likes
mcdasa
in Database migrations to Azure SQL Managed Instance - Restore with Full and Differential backups on May 16 2022 01:49 AM
@ashricky89 Can we have any option for Azure SQL Database, not many companies can afford to use MI for every service.We need diff backup like mthods(or transaction log shipping) for migrating on-prem to azure-sql. So we can have short maintenance time for production service.
0 Likes
Fredy_Rivera
in Copy files from Mainframe to Azure Data Platform using ADF FTP Connector on Mar 08 2022 12:54 PM
Thanks @Sandip_Khandelwal , please confirm us the information about using SFTP to access the mainframe.
1 Likes
Sandip_Khandelwal
in Copy files from Mainframe to Azure Data Platform using ADF FTP Connector on Feb 28 2022 06:45 AM
@Fredy_Rivera For VSAM files you need to convert VSAM files to Physical sequential files on Mainframe using IDCAMS utility and then transfer converted Physical sequential files with the process mentioned in above blog.
1 Likes
Fredy_Rivera
in Copy files from Mainframe to Azure Data Platform using ADF FTP Connector on Feb 17 2022 06:12 AM
Thanks @Sandip_Khandelwal ... any idea how to make it work with VSAM files? I'm currently working in a project where we need to do that kind of transfer.
0 Likes