SSIS is only for data loading operation...how we can migrate other DB objects?
Yes we can ..we have migrated around 2TB of database into Postgres.. we need to use Intellisoft driver . But We need to buy the license.
If you migrating with schema changes we can use ssis . Otherwise direct mapping without any schema changes . we have many tools available in the market .
Like FullConvert, dbconvert, spectralcore, pgloader.io.. etc