Task #997
Port DB (schema + data) from Oracle to MS SQL Server
| Status: | Closed - End of life cycle | Start date: | June 13, 2011 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | % Done: | 100% | ||
| Category: | - | Spent time: | 38.00 hours | |
| Target version: | - |
History
#1
Updated by Ahmadi Hadi over 13 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 0 to 50
A program was created to automatically export the schema and data using hibernate mappings. The process, however, is not fully automated since the hibernate mappings generated from Oracle schema still need some tweaks (like changing the 'serializable' types to 'timestamp', and also some modifications for the relations and sequences/generators). An exported and populated schema is already available on our MS SQL Server with the following details:
connection.url=jdbc:sqlserver://192.168.1.99:1433;databaseName=agroib
connection.username=agro_ib
connection.password=perempuan
Switching the datasource is still not possible as I've noticed there are some Oracle specific queries in the current code base, like executing SELECT ... FROM DUAL.
#2
Updated by Ahmadi Hadi over 13 years ago
Modified all HBM mappings in agro-ibssCore project to make them portable to SQL Server. Some of the modifications have caused runtime issues in the system, for which I've been testing and debugging the system for last 8 hours!
#3
Updated by Ahmadi Hadi about 13 years ago
- Status changed from Development / Work In Progress to Internal Testing
- % Done changed from 50 to 90
The DB Schema and its data has been ported to the SQL Server and except two sequences (IB_SEQ_SESS and IB_SEQ_TRNX) which have been simulated, the rest of table primary keys are generated using "generator class=native", which in turn translates to "identity" on SQL Server.
#4
Updated by Ahmadi Hadi about 13 years ago
Worked with the team to resolve issues raised by the migration to SQL Server.
#5
Updated by Wong Bernard about 13 years ago
These tables are missing in the MSSQL database:
- IB_REGISTRATION
- IB_USER_PRINT_RECEIPT
#6
Updated by Ahmadi Hadi about 13 years ago
Done in the following changeset:
https://hub.penril.net/hg/agrobank/agro_rib/rev/2c6563e323b5
#7
Updated by Ahmadi Hadi about 13 years ago
- Status changed from Internal Testing to Closed - End of life cycle
- % Done changed from 90 to 100