1/4/2023 0 Comments Aws postgresql dump ec2![]() ![]() If you use json data type in your db, you may come across this case when migrating from PG to PG. Partial support on the other hand means DMS can migrate these data types but only under certain conditions. If that’s a deal breaker then you may need to evaluate other options for migration. If you are using data types which are not supported, then those columns won’t get migrated. ![]() You can even create dummy endpoints and tasks just for this purpose - even a source db with just the schema loaded should be sufficient. For that, make sure you check the “Pre-migration assessment” option when starting the task. ![]() One good thing is that databases can be checked beforehand for compatibility so that there are no surprises during migration. tsvector whereas others that are supported partially eg. There are some pg data types which are not supported at all eg. There are certain limitations about which data/column types are supported. Refer AWS documentation for complete list of prerequisites.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |