Post reply

Data Migration Assistant Tool

  • November 27, 2019 at 2:26 am

    #3701298

    Hi

    We are in the process of trying to migrate from MSSQL 2008 to 2017 SE.

    We are looking into data migration assistant.

    1. We would like to ask when we execute the migration of a database from source to target, what happen to the source once it is completed?

    2. Will it delete or take offline the database in the source ?

    3. Is there any free tools that will migrate:

    SQL Server Agent:

    - jobs

    - alerts

    - operators

    Management:

    - Maintenance Plans

    - Database Mail

    Server Objects:

    - Linked Server

    - Backup Devices

    Security:

    - Logins

    and etc, server settings ?

    Thanks.

     

     

     

  • November 27, 2019 at 2:33 am

    #3701299

    I thought you could just open a 2008 database in 2017?

  • November 27, 2019 at 8:31 am

    #3701441

    We want to migrate all component from old sql server 2008 (server a) to new sql server 2017 (server b).

  • November 27, 2019 at 1:22 pm

    #3701504

    1. Nothing
    2. No

    took about 2 minutes to create a new DB on a test system and evaluate the tools I want to use, you leave knowledge and testing to others? How do you intend to do your migration? Fire once and hope nothing breaks? What will you be doing when things actually break during migration?

    Not trying to offend you but when you evaluate new SQL Versions you usually have a look at which Edition supports what so you don't end up wondering why you can't install SSIS Scale Out Master on SE afterwards.

    So if I tell you Tool XYZ might cover all your requirements from 3. what do you do? Buy the software for potentially a lot of $$$$$$$ right away and set a migration date or would you test your tools and requirements of your tools? If you don't test your tools (including DMA) I already feel sorry for you, if you do - why not DMA?

  • November 27, 2019 at 1:53 pm

    #3701530

    I'm not aware of a tool that will do the work for you. However, check out DBATools. This software will make the migration easier, if not easy. Here's an example.

    As for the rest, testing is your buddy. Test everything. It's the only way to know.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • November 29, 2019 at 7:59 am

    #3702049

    Thanks all. We have manually migrate the jobs, alerts, maintenance plans and etc.

    For SSIS especially with those still having old DTS 2000 Package - transform data task, it cannot be migrated or converted.

    It need to be manually change to the SSIS new way of working. New version of SSDT 2012 is not able to proper convert it.|

    Can't find a tool to do it automatically. This will required a lot of work.

    Other than that other seems to be fine.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply