Hi
I am just wondering how difficult it is to change databases say from Derby to MSSQL once we have started (a live system is in use). Going forward we may well become more reliant on the AwareIM software (as we were surprised how capable it has turned out to be) but we have resevations about the stability and problem solving capabilities available to us with the Derby Database (as nobody knows anything about it)
Is this very difficult to do? and could you give me any pointers of how I might start or where to look for further information?
Regards
John
changing databases
Hi John,
Support will certainly give a more complete answer, but I have used import & export functions very successfully in other scenarios.
Here are steps I would try:
1- Make copy of Derby-connected BSV & connect it to MSSQL (no data here yet)
2- Export all data from Derby BSV
3- Import all data to MSSQL BSV
4-- Test accuracy of data
Hope this helps,
Tom
Support will certainly give a more complete answer, but I have used import & export functions very successfully in other scenarios.
Here are steps I would try:
1- Make copy of Derby-connected BSV & connect it to MSSQL (no data here yet)
2- Export all data from Derby BSV
3- Import all data to MSSQL BSV
4-- Test accuracy of data
Hope this helps,
Tom
John,
Having done a data transfer recently I can tell you that it is not an easy task. It depends on how much data you have and how complicated are relationships between your tables. It is a straightforward process to export and then import a flat table. However you will likely need to edit an exported table if you have a reference attribute. Note, if you open a csv file in Excel and some of your data start with '0', Excel will remove the preceding zero. Another potential problem is with long numbers, like a credit card number stored as a string. Excel will convert it to a scientific notation.
Good luck
greg
Having done a data transfer recently I can tell you that it is not an easy task. It depends on how much data you have and how complicated are relationships between your tables. It is a straightforward process to export and then import a flat table. However you will likely need to edit an exported table if you have a reference attribute. Note, if you open a csv file in Excel and some of your data start with '0', Excel will remove the preceding zero. Another potential problem is with long numbers, like a credit card number stored as a string. Excel will convert it to a scientific notation.
Good luck
greg