# Oracle database Database schema migration to MSSQL database

**URL:** <https://forum.liquibase.org/t/oracle-database-database-schema-migration-to-mssql-database/2191>\
**Category:** General Discussion\
**Created:** [February 4, 2013, 3:47pm UTC](https://forum.liquibase.org/t/oracle-database-database-schema-migration-to-mssql-database/2191 "2013-02-04T15:47:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [February 4, 2013, 3:47pm UTC](https://forum.liquibase.org/t/oracle-database-database-schema-migration-to-mssql-database/2191/1 "2013-02-04T15:47:00Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [February 4, 2013, 3:47pm UTC](https://forum.liquibase.org/t/oracle-database-database-schema-migration-to-mssql-database/2191/2 "2013-02-04T15:47:00Z")

</div>

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