OraFAQ Forum: Programming Interfaces » synchronizing data from sql server

Home » Open Source » Programming Interfaces » synchronizing data from sql server (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

synchronizing data from sql server [message #647168]

Thu, 21 January 2016 01:40

m.abdulhaq
Messages: 253
Registered: April 2013
Location: Ajman

Senior Member

i have a time clock software which is based on sql server 2012, basically one table in sql server where employee punch in and punch out data are recorded, now i want to push this data into our oracle database on hourly basis from sql server , what approach will be best suited for doing this.

Report message to a moderator

Re: synchronizing data from sql server [message #647169 is a reply to message #647168]

Thu, 21 January 2016 01:45

Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you want to push it from SQL Server then you should post your question in a SQL Server forum not in an Oracle one.

Report message to a moderator

Re: synchronizing data from sql server [message #647174 is a reply to message #647169]

Thu, 21 January 2016 04:26

JNagtzaam
Messages: 36
Registered: July 2015
Location: Alkmaar

Member

Maybe he wants to pull it?

If so:
1)create a database link to SQL Server.
2)create a materialized view on the table over the db link, that refreshes every hour.

Other option: Oracle Golden Gate

Report message to a moderator

Re: synchronizing data from sql server [message #647176 is a reply to message #647174]

Thu, 21 January 2016 04:28

Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is not push, this is pull, so this is not the question.

[Updated on: Thu, 21 January 2016 04:28]

Report message to a moderator

Re: synchronizing data from sql server [message #647178 is a reply to message #647176]

Thu, 21 January 2016 04:50

JNagtzaam
Messages: 36
Registered: July 2015
Location: Alkmaar

Member

That's what I already stated.
Besides, not everyone knows how to ask the right questions...
And it is a solution Wink

Report message to a moderator

Re: synchronizing data from sql server [message #647188 is a reply to message #647176]

Thu, 21 January 2016 09:02

m.abdulhaq
Messages: 253
Registered: April 2013
Location: Ajman

Senior Member

i apologize , what i actually meant was "Pull" data from sql server.

Report message to a moderator

Re: synchronizing data from sql server [message #647189 is a reply to message #647188]

Thu, 21 January 2016 09:37

Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So this is a SQL Server question NOT an Oracle one.
The topic is locked. /forum/fa/448/0/

If I'm wrong, please, PM me (or report this message to a moderator, explain why you think it should be unlocked and it might be done).

Report message to a moderator

Re: synchronizing data from sql server [message #647213 is a reply to message #647189]

Fri, 22 January 2016 11:43

Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Received in PM.

m.abdulhaq wrote on Fri, 22 January 2016 17:35

i am sorry michael , i made a mistake i need to pull data into oracle from sql server.

It is my mistake for not defining the problem correctly.

This is still not clear
So you have to define:
1/ What is the source?
2/ What is the target?
3/ Who process? the source (push) or the target (pull)?

Report message to a moderator

Re: synchronizing data from sql server [message #647217 is a reply to message #647213]

Fri, 22 January 2016 21:55

m.abdulhaq
Messages: 253
Registered: April 2013
Location: Ajman

Senior Member

Quote:

So you have to define:
1/ What is the source?

Source is table from Sql Sever

Quote:

2/ What is the target?

Target is a table in Oracle.

Quote:

3/ Who process? the source (push) or the target (pull)?

Need to schedule it on every 30 minutes whatever new data in sql server data will be update into Oracle table.

I hope this clarifies.

Report message to a moderator

Re: synchronizing data from sql server [message #647218 is a reply to message #647217]

Sat, 23 January 2016 01:20

Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Need to schedule

In SQL Server or in Oracle?

Report message to a moderator

Re: synchronizing data from sql server [message #647222 is a reply to message #647218]

Sat, 23 January 2016 03:49

m.abdulhaq
Messages: 253
Registered: April 2013
Location: Ajman

Senior Member

In oracle.

Report message to a moderator

Re: synchronizing data from sql server [message #647223 is a reply to message #647222]

Sat, 23 January 2016 03:52

Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Create a database link in Oracle to SQL Server and a materialized view which will refresh hourly.

Report message to a moderator

Re: synchronizing data from sql server [message #647229 is a reply to message #647223]

Sat, 23 January 2016 10:49

m.abdulhaq
Messages: 253
Registered: April 2013
Location: Ajman

Senior Member

thanks Michael.

Report message to a moderator

Previous Topic:	Downloaded 114 BLOBS using PHP before getting ORA-12537: TNS Connection Closed
Next Topic:	ora_lob_read failed: ORA-01403: no data found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 13 10:30:44 CDT 2020