Microsoft/MigrationPlaybook

H. James Toland III

@HJToland3

@rishiagrahari_twitter, migrating from an on-premises instance of MySQL or a MySQL instance hosted in a virtual machine to Azure Database for MySQL is considered a homogeneous migration. Azure Database for MySQL automatically manages patching for minor version updates. Azure Database for MySQL supports versions 5.6.3.5 and 5.7.1.8 using the InnoDB engine, so if you are running a supported version in on-premises MySQL, the database will be fully compatible, and the migration will be relatively straightforward.

If you have MyISAM tables, convert them to InnoDB before you migrate them to Azure Database for MySQL. For more information, see the MySQL article Converting Tables from MyISAM to InnoDB at https://dev.mysql.com/doc/refman/5.6/en/converting-tables-to-innodb.html.

rishi agrahari

@rishiagrahari_twitter

Hi, Is trigger and view is also compatible on azure MySQL?

H. James Toland III

@HJToland3

@rishiagrahari_twitter, yes they are. When importing Views, be sure to remove the DEFINER clause.

rishi agrahari

@rishiagrahari_twitter

One last doubt, Is Azure db for MySQL support cross database queries? and can you provide any assesment report related to MySQL migration to Azure db for MySql.

H. James Toland III

@HJToland3

@rishiagrahari_twitter, I think your question is whether Azure Database for MySQL supports cross database server queries, which require the Federated storage engine. Azure Database for MySQL does not currently support the Federated storage engine, so cross database server queries are not yet available. Re an assessment report, I am not aware that we have a specific resource to point you to, however, you can review a number of customer case studies about migrating to Azure Database for MySQL on Microsoft's Customer Stories site at https://customers.microsoft.com/en-us/search?sq=%22Azure%20Database%20for%20MySQL%20%22&ff=&p=0&so=story_publish_date%20desc.

Vijay Prabhakar

@vprabhakar_gitlab

Hi Team, I facing issues while adding endpoints. Getting below error.

SYS-E-HTTPFAIL, No valid MySQL ODBC 5.x Unicode Driver is installed. The required ODBC driver or driver manager is not properly installed and configured..

@HJToland3

H. James Toland III

@HJToland3

@vprabhakar_gitlab, can you provide any additional detail/context regarding your query? This will help us better respond. Thanks!

Ashish Gupta

@ashishgupta0612_twitter

I need to migrate on premises DB PostgreSQL ver 9.* to Azure SQL , without using third party tool. How can I achieve it..?

H. James Toland III

@HJToland3

@ashishgupta0612, please contact me directly at jtoland@microsoft.com to discuss your migration scenario and requirements. Thanks!

Prema Arya

@premaarya

Hi need information on migrating postgreSQL on BSD platform to Azure PostgreSQL

Database size is < 25GB

H. James Toland III

@HJToland3

Hi @premaarya. Have you already reviewed the details in our Azure Database for PostgreSQL documentation? For example:

https://docs.microsoft.com/azure/postgresql/howto-migrate-using-dump-and-restore; https://docs.microsoft.com/azure/postgresql/howto-migrate-using-export-and-import

If so and you've not gotten the information you need, please contact me directly at jtoland@microsoft.com to provide more detail about your migration scenario and requirements. Thanks!

DwaneTuitt

@DwaneTuitt

Good day

I need some help

H. James Toland III

@HJToland3

@DwaneTuitt - How can I assist?

@gaylard_gitlab

hi, we're looking to migrate a system from Oracle to Azure SQL. Basically, it looks like the Azure DMS is designed only if you're basically replicating your existing data model in Azure SQL. It's expected that the data model for our new system will likely be very different. Basically, it looks like DMS is good for extraction and load, but doesn't do transformation between different data models. My question really is, can DMS assist with transforming between different data models?

H. James Toland III

@HJToland3

@gaylard_gitlab, DMS only performs the data migration. You need to use SSMA for schema conversion from Oracle to Azure SQL Database or ora2pg for schema conversion from Oracle to Azure Database for PostgreSQL.

Ahmadreza

@ahmad2x4

Hi, We are looking into migrating our MS SQL Databases (SQL 2014) from EC2 instances hosted on AWS to Azure SQL Database (MI) databases sizes currently 3-4 TB and backup/copy/restore is not probably the best solutions. Do you recommend using DMS or setting up a transactional replication for migration to minimise down-time?

H. James Toland III

@HJToland3

@ahmad2x4, we'd recommend using DMS over transactional replication for your scenario.

Masashi Onodera

@masashioms

Hi, From SQL Server 2012 to SQL Server 2017 scenario, migration guide says that the transnational replication from SQL2012 to SQL2017 is the supported migration option. But it is not supported option, according to the following document. It says that if SQL2012 is a publisher, the subscriber is up to SQL2016. Which is correct?

https://docs.microsoft.com/en-us/sql/relational-databases/replication/replication-backward-compatibility?view=sql-server-2017#replication-matrix

H. James Toland III

@HJToland3

@masashioms - the information at the docs link is accurate - I am updating the DM Guide accordingly. Thanks for calling out the discrepancy!

Adam

@azach2878

Hi, we're looking to migrate over 50 on-prem SQL servers to Azure, I am thinking about migrating to SQL-DW. any suggestions ?

H. James Toland III

@HJToland3

@azach2878, Azure Database Migration Service does not currently support migrations from SQL Server to Azure SQL DW. We do provide some guidance here (https://datamigration.microsoft.com/scenario/sql-to-sqldw?step=1), but it's primarily for smaller migration projects.

Adam

@azach2878

@HJToland3 Thanks. I have another question! Is it like a good practice to migrate all my SQL database server to Data Warehouse solution ? We will decommission our on-prem servers end of this year.

@HJToland3 I am thinking about migrating our on-prem SQL servers to SOL IaaS, then back it up to a blob storage, and then building our data factory & data warehouse solution... I need an advice please

H. James Toland III

@HJToland3

@azach2878, please address your questions to the AskAzureDatabaseMigrations@service.microsoft.com alias. Thanks!

pramodgaur83

@pramodgaur83

Hi All, Kindly share resources for Migration from Oracle to Azure Database for PostgreSQL. Please provide suggestions ??

pramodgaur83

@pramodgaur83

@pramodgaur83 : Hi Team, Kindly share suggestions..

fixahost

@fixahost_twitter

Hi guys

I need Get Tables specifics in SQl Local to SQL Local i know the tool DMA V3.3 is good for this, but i can´t find it, someone here have the file for share ?

fixahost

@fixahost_twitter

someone ?

H. James Toland III

@HJToland3

@fixahost_twitter, will DMA 4.4 (https://www.microsoft.com/en-us/download/details.aspx?id=53595) not work for your purposes?

@pramodgaur83, the ora2pg utility will work for this purpose. We also preview support for migrating Oracle to Azure Database for PostgreSQL online using DMS.

fixahost

@fixahost_twitter

@HJToland3 not work about i need

i need version V3.3 or maximum 4,0

H. James Toland III

@HJToland3

@fixahost_twitter, we generally replace older versions of tools when we publish later versions. As a result, only the latest version is available on the Microsoft Download Center.

fixahost

@fixahost_twitter

Yes i know James, but in the before version have one tool very good

the actually no have

H. James Toland III

@HJToland3

@fixahost_twitter, we don't have the earlier version available for download any longer. What is the issue with using the latest version, DMA 4.5 (https://www.microsoft.com/download/details.aspx?id=53595)?

: s c r u f f t y :

@scruffty_twitter

hello, can anyone help please? when running the DMA on 2008R2 I click sign in to Azure and the program crashes to the desktop, with no error message. I am using a proxy and have tried with 2 different 2008R2 "jump" boxes...

H. James Toland III

@HJToland3

@scruffty_twitter, can you send this query directly to the Data Migration Assistant Feedback alias, and be sure to specify which target you are selecting as well? Thank you!

fixahost

@fixahost_twitter

Guys look the article, i need that version

http://oakleafblog.blogspot.com/2010/01/using-sql-azure-migration-wizard-v313.html

H. James Toland III

@HJToland3

@fixahost_twitter, are you speaking about George Huey’s SQL Azure Migration Wizard (SQLAzureMW) v3.3? This is a wholly different tool than the Data Migration Assistant (DMA). I am just trying to clarify your ask. Thanks!

fixahost

@fixahost_twitter

Hi James, but where can put download

Yes i know , i need the toolf V3.3 xD

SqlAzureMW

Where communities thrive

People

Repo info

Activity