With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
There is a student housing system that is installed and using Oracle DB. A new application was developed using MS SQL. Some data are needed to be transferred from the Oracle DB to the MS SQL server.
• The requirements are to have a windows based script that can execute an Oracle SQL query and retrieve the data and after that upload the data to the MS SQL and there are 2 main steps here:
1- To get the whole data at the beginning from Oracle and then load it to MS SQL.
2- To get whatever updated in Oracle from the last successful synchronization and upload them to MS SQL.
• The script should be able to work with both MS SQL 2000 and MS SQL 2005
• The script should run automatically every 1 minute.
• There should be a log with the script with date and time for each step taken.
• The source code of the script is needed.
• The Oracle query will be provided later on. No need to built the query, it will be delivered.
• The M...
Sign in or Register to see more