I need to migrate my Oracle 9i database with all its tables from windows server 2003 to MySql on another Windows Server 2012. The oracle database is connected to Visual Studio web project. I have successfully imported the files (.aspx) to Microsoft Visual Studio 2013 Community edition.
(Mind that I need to keep original database intact for few weeks of testing peroid, simply the migration should be , creating a clone copy and not moving the database.)
I am facing problems as the visual studio project has code for connection with old oracle database. I need to recreate the functioning website.
The only thing remaining is migrating that old database to new server.
I tried SQLWays . But It does that on single machine not from another server.
Please suggest solutions for migration between different servers.
Further, what needs to be changed in my vb code even if I migrated the database successfully to get it working with visual studio 2013 project.
(or may I ask a different question for that?)
Me.OleDbDeleteCommand1.CommandText = "DELETE FROM DISEASE WHERE (DIS_IDS = ?) AND (DIS_FNAME = ? OR ? IS NULL AND DIS_FNAM".......