by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    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)?
    : 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 dmafeedback@microsoft.com 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
    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
    H. James Toland III
    @HJToland3
    @fixahost_twitter, my team works on DMA, not SQLAzureMW. I think the blog post you link to above is the best option for finding out more about that tool.
    fixahost
    @fixahost_twitter
    But the product DMA is provide on SQLAzureMW not ?
    H. James Toland III
    @HJToland3
    @fixahost_twitter, DMA is a separate tool from SQLAzureMW, and no versions earlier than DMA v4.5 are available.
    fixahost
    @fixahost_twitter
    ok
    Louis Page
    @lbpage
    Is it possible to setup migrations from sql server to azure postgres, if so is there a guide?
    Pankaj Bagzai
    @pbagzai_twitter
    H. James Toland III
    @HJToland3
    @lbpage, migration from SQL Server to Azure Database for PostgreSQL is possible, but we don't currently have first party tool or a migration guide for this scenario, nor is one on our immediate road map.
    HoveringHalibut
    @HoveringHalibut
    Does the DMS tool support migrations from AWS Aurora to Azure Database for PostgreSQL? I'm not finding any mention of it.
    H. James Toland III
    @HJToland3
    @HoveringHalibut, this is not currently a supported scenario. See the article Status of migration scenarios supported by Azure Database Migration Service at https://docs.microsoft.com/azure/dms/resource-scenario-status.
    Swetha MS
    @SwethaSharath_twitter
    Hello, I m looking for migrating clear quest data to Azure. Is it possible if yes how can this be done?
    payyan5
    @payyan5
    Hi, I'm looking for planning guide for Oracle to SQL Server migration using SSMA
    H. James Toland III
    @HJToland3
    H. James Toland III
    @HJToland3
    @SwethaSharath_twitter - Checking for you... Will get back ASAP.
    payyan5
    @payyan5
    @payyan5 Thanks James. I will check it out.
    Sean Whitesell
    @seanw122
    I need to check my understanding on the Data Migration Service. If I have two SQL Servers, one is receiving all the load. The other needs to be in sync. Does DMS keep the two servers in sync? If I was to swap which server is the primary, do I need to have downtime > 1 minute? Thanks!