1

I'm trying to use Microsoft's SQL Server Migration Assistant for Sybase 5.3 ('SSMA') to migrate multiple Sybase databases (that have the same schema) to a single MSSQL database.

The first database migrated fine. But when I try to migrate data from the next one, I see lots of warnings like:

The table 'MyDatabase.dbo.MyTable' contains data. If you continue with data migration, all data in the table will be deleted.

I don't want the existing data to be deleted, but can't find a way to do this in SSMA.

Improve this question

1 Answer 1

Reset to default
1

I figured it out. I had to go to Tools > Options > General > Migration and set Extended data migration options to Show.

Then I had a new Data Mig... tab for each table, and had to uncheck Truncate SQL Server table and hit Apply individually for each table. Rather laborious when you have a lot of tables... but it worked.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.