SSMA tool shortcomings ?

  • Abhishek

    SSCommitted

    Points: 1700

    I prefer to use ssma tool to perform the database migrations from older versions of SQL server to newer versions but could see the tool has a few shortcomings like it deletes the backup files after restoring , it wont change the database owner , compatibility level of the restored databases , it wont fix the orphan users , transfer linked servers etc so the scope left is pretty basic ( backup/restore db along with permissions) . Some improvement can be expected from the tool in the days to come

     

  • Site Owners

    SSC Guru

    Points: 80378

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

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