Migrate 260 tables from ingres to SQL Server

Question

I am migrating an ingres database to SQL Server.

This database has 260 tables to migrate.

I usually use SSIS, I create a package for each table, that will be 260 packages, and then I run one by one for SSIS itself.

I would like to know if you have an easier and faster way to do this migration?

Thank you.

Answer 1

You should use SSMA for oracle https://learn.microsoft.com/en-us/sql/ssma/oracle/migrating-oracle-databases-to-sql-server-oracletosql?view=sql-server-2017

Answer 2

I think that the simplest way is to use the SQL Server Import and Export wizard, since it allows migrating multiple tables in one operation:

• How to copy multiple tables from ingres database to sqlserver database ?