Activity overview
Latest activity by alexandr.kirpichny
Hi Peterpj, Thanks for outlining your challenge. Migrating a database schema and data to a new database with a different structure can indeed be tricky, especially when the target database is more comprehensive. It sounds like you need a solution that can handle schema differences, data transformation, and potentially data enrichment during the migration process. As the guys have mentioned above, SQL Compare can help migrate the schema. For handling the data migration, including adapting to the new structure, you might want to explore specialized database migration tools. One option to consider is SQLWays by Ispirer. This tool has been designed to automate much of the migration process, including schema conversion, data type mapping, and even handling differences in table relationships. It provides features to customize the migration rules, which could be helpful in your scenario where the target database has additional tables and a more comprehensive structure. Remember to thoroughly plan your migration, test the process in a non-production environment first, and document every step. Good luck with your database migration! Best regards, Alex Kirp / comments
Hi Peterpj,Thanks for outlining your challenge. Migrating a database schema and data to a new database with a different structure can indeed be tricky, especially when the target database is more c...