Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Arafatul Hasan
    @HasanArafatul_twitter
    Hi, I want to migrate sql server 2017on Azure VM to sql data warehouse in azure. I have check this website which does not show target as sql dw in azure. How can I find it?
    Arafatul Hasan
    @HasanArafatul_twitter
    @harinid Hi, I want to migrate sql server 2017on Azure VM to sql data warehouse in azure. I have check this website which does not show target as sql dw in azure. How can I find it?
    pawank007
    @pawank007
    Hi
    I want to migrate a database (for now assume it as MSSQLserver) to a Windows VM +SQLserver on a Azure IaaS through ASR, what details I need to complete the entire migration (will create a database for migration purpose), can anyone please suggest step-by-step solution?
    H. James Toland III
    @HJToland3
    Hi @pawank007. While this info is not yet available via the Migration Guide, you might want to check out the article Migrate on-premises machines to Azure.
    rishi agrahari
    @rishiagrahari_twitter
    hi,
    I want to migrate MYSQL db on azure , what need to modify in my db?
    what data type,functions,procedure etc not supported on azure?
    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:
    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?
    g
    @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)?