I am new to database management. I need to copy a particular table "Attendance" in SQL Server database to Oracle database. There is no connection between the two databases. Also, "Attendance" is updated in real-time in the original SQL database.
I have two options:
To pull the data from SQL Server -> Store it -> Push to oracle.
Connect the two databases so as the updates are synchronised in real-time.
Unfortunately, I don't know how to go about this. I have researched on this since a week but haven't found exactly what needs to be done.