Oracle database Database schema migration to MSSQL database

Is it possible to migrate oracle database schema to MSSQL database schema by using Liquibase? Any help on how to do it by using Liquibase would be appreciated.

Yes, it is possible. I use it at my work to maintain test datasets in mysql and also be able to run them in sqlserver.


Basically what you want to do is a generateChangeLog against the sqlserver database, then run that changelog against oracle. There may be some search and replace changes you need to make around types and removing autoincrements in favor of sequences, but that can easily be scripted with an XML program if need be.


Nathan