Data Analysis & Migration

Lionsgate Software consultants have done 6+ large data analysis and migration projects among Oracle, MS SQL Server and Informix for both public sector and commercial clients.mdm

While we do data migration or ETL, we also do Metadata / Master Data Management (MDM), database design optimization, including name convention, transaction system re-design, null-blank conversion, data cleansing and unifying table structure, etc. Our goal is to maximize your database performance after data migration.

There are two flows to handle MDM, one is Semantic Lineage, another is Data Flow as shown in right figure.

We own ETL tool DataEx to achieve large volume data migration from Informix to Oracle.

Along with data migration, our unique strength is that we know how to make your data accessible online, without designing and developing costly portal application, which saves your time and money.

With the outstanding capabilities on data modeling design, Lionsgate Software consultant also achieved lots of data migration projects which came along with the data modeling redesign. Here are part of the data migration projects that were achieved by us:

LocationSource Data StoreTarget Data StoreClient
BC, CAOracleOracleMoF
BC, CAMS SQL ServerMS SQL ServerCarrier Lumber
BC, CAOracleOracleWFM
MB, CAMS Access and Excel spreadsheetsOracleProv. MB
AB, CAInformixOracleAlpac
BC, CAMS AccessOracleTranslink
ON, CAOracleMS SQL ServerTembec

Lionsgate Software is familiar with below databases and languages:database_icon

  • Oracle (PL/SQL)
  • MS SQL Server (T-SQL)
  • Sybase
  • Informix
  • MS Access
  • ESRI ArcSDE (spatial DB)
  • MongoDB (NoSQL DB)


  • TOAD
  • Oracle SQL Developer
  • MS SQL Query Analyzer

Should you have any questions, please let us know. Start saving on your IT costs today.contactus4