Tran-Hoang_Hau_348

Switch from MS SQL to Oracle

Discussion created by Tran-Hoang_Hau_348 on Jan 23, 2017
Latest reply on Feb 22, 2017 by Darren_Sniezak_40
This question has been asked so far.

We were thinking about switching our AWA install from MS SQL to Oracle, our questions: 

1) What versions of Oracle do you support? 
2) Are there any tools to help with the migration? 
3) Do I need to copy the objects via a transport case or can I export and import the system as a whole? 
4) Is there anything we should watch out for making this move?

==>
1. https://docs.automic.com/tools/compatibility_checker?compatibility-mode=component&lifecycle_entity_id=1409143059253

xuxl2pz92gz8.png
2.  The tool you may need to migrate the data from MS SQL to Oracle
- Client copy can work accross platfom 
- Load/Unload utility

https://docs.automic.com/documentation/WEBHELP/English/AWA/11.2/AE/11.2/All%20Guides/help.htm#ucablx.htm%3FTocPath%3DAdministration%2520Guide%7CUtilities%7C_____1

3.4 If you export the current system (MSSQL) via transport case and transport it to Oracle system, Please make sure that you having the same version in both platform.
and always test first before moving to production

Outcomes