How to: Migrate to a schema in an existing database using SSMA

  • Article

SSMA, by default, migrate to dbo schema in a SQL Server database with the same name as source database schema you are migrating from. If the database does not exists, then SSMA will prompt if you like to create a new database. You can modify the target migration to an existing database with the following steps:

  1. Open/create new SSMA project
  2. Connect to source database
  3. Connect to SQL Server (and specify the database name – make sure to match the case for database name)

ConnectToSQLServer

  1. Select the schema to be migrated and click modify

ModifySchemaTarget

  1. Choose target schema (using the following convention servername.schemaname – make sure to match the case for database name)

ChooseTargetSchema

  1. If the target schema does not exist, SSMA prompt confirmation window. Click yes to continue

CreateTargetSchema