I'm using SQL Server Migration Assistant
for data migration from MySQL to SQL Server. I would like to know whether it is possible to migrate data from databases of different names but tables inside databases have the same names.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
IDENTITY
and MySQL usesAUTO_INCREMENT
... be aware