MSSQL Server and Oracle DB Developer

I am dba having more then 10 yrs of experience. I will make ssis pakage and put it in sql jobs which will daiky replicate the table in Oracle

Best way would be to create a ssis package which exports the data to your oracle table on a daily interval and schedule it as a job Another way To Create a database link from Oracle to Sql Server (heterogeneous connectivity). We can use this link to retrieve the data from Sql Server with a simple select statement. If you want to schedule you can use a materialized view or dbms_scheduler. But this will need some amount of configuration at oracle end

SQL server has utility (SSIS + JOB) that will automatically replace your table from SQL SERVER to Oracle on scheduled time. (i.e. Everyday at 06:00 AM) I think it will resolve your requirement. Please message me I am available now. Please review my profile. I have 4.2 years experience in SSRS, SSIS and 7 years experience in SQL. Please let me know more details and when will we start. Skype: jikenjd

Hello there, Here is the proposal for your project:- Step 1: Connect to SQL server Step 2: Export the required table using bcp utility. Step 3: Define the parameters for exporting the table as per the Oracle database Step 4: Move the file to Oracle database server Step 5: Connect to Oracle database Step 6: Import the table to Oracle database using imp utility. Step 7: Check the imported data Step 8: Once above steps are successful, these can be wrapped in a script (batch file, bash script, perl etc) Let me know if you have any questions. Regards NK

We have 8+ years of experience Team on supporting Remote DBA services on Microsoft SQL server DB , Oracle, And MySQL. If you have any questions about my expertise of DBA please ask me questions I will happy to give you the answer any time. Our Remote DBA services lead the industry in database administration and 24×7 support for SQL Server, Oracle, MySQL. Comprehensive Remote DBA Services Our Remote DBA Services consist of the following components: * 24X7 remote DBA support (governed by industry-leading SLA) * Proactive database administration and performance management * Database monitoring and alerting * On-demand consulting services * Optional Part-time DBA service. Cross-Platform Remote DBA Support We support complex database applications across all major platforms: Microsoft SQL Server Oracle MySQL Thanks

I have More then 3 years of an experience with sql server and oracle. Thanks

Expert on such integration project..working as SME in leading MNC..passionate developer and manger. Problem solving is my USP.

Hello Sir, I hope you are fine, i read your project description and i have more than 2 year experience in oracle, C# , .NET , MS SQL i will done your project in very less time and in very less Cost to the others. i hope you will give me a chance to work with you, i also have done same project done previously that why i said i will done you project in very less time. Thanks Regards: Awais Alyas software developer

Hi, I'm having more than 5 years of exp on MS SQL Server and I will assist you to make your project successful. Proposed Approach : - There is very good technique through one of the High availability solution in SQL Server 2008R2 which automate your copy/replace the database object like tables/views/SP etc and you can schedule this task to happen periodically as per your requirement generally in non-business hours.

Hello, I have lot of development experience in databases, like Oracle and MSSQL Server. I nead a connection between the databases (dblink), or I can connect them, and create a stored procedure, whitch will copy the table from MSSQL Server to Oracle, daily.

Will provide a data integration service than can be configured in windows task scheduler to be very easy to handle by any end user (even non-technical).

A proposal has not yet been provided

SSIS package can be created and schedule in particular timing to migrate.

A proposal has not yet been provided

I can write a windows service for you in .net that can run once a daily or multiple times as you wish and will copy the data from Sqlserver db to Oracle db. I have 8 years of experience working in .net, sql and oracle and I have already worked with services. I am sure that I will complete your task successfully. I am new to Freelancer so you will not get any reviews about me.

I can create application to select data from any database and insert this data to any database using c#

Hi, I have around 4.5 years of working with data from different sources. My approach would be 1. Creating a SSIS package with Source as SQL Server and destination as Oracle I would like to help you with this requirement. Thanks, Shadab.