Sample Header Ad - 728x90

Don't delete exist data with SSMA

1 vote
1 answer
1728 views
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.
Asked by Cocowalla (191 rep)
Aug 7, 2014, 09:19 AM
Last activity: Dec 17, 2015, 05:05 AM