Home » Open Source » Programming Interfaces » synchronizing data from sql server (10g)
synchronizing data from sql server [message #647168] Thu, 21 January 2016 01:40 Go to next message
m.abdulhaq
Messages: 233
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.
Re: synchronizing data from sql server [message #647169 is a reply to message #647168] Thu, 21 January 2016 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 65254
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.

Re: synchronizing data from sql server [message #647174 is a reply to message #647169] Thu, 21 January 2016 04:26 Go to previous messageGo to next message
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
Re: synchronizing data from sql server [message #647176 is a reply to message #647174] Thu, 21 January 2016 04:28 Go to previous messageGo to next message
Michel Cadot
Messages: 65254
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 Go to previous messageGo to next message
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
Re: synchronizing data from sql server [message #647188 is a reply to message #647176] Thu, 21 January 2016 09:02 Go to previous messageGo to next message
m.abdulhaq
Messages: 233
Registered: April 2013
Location: Ajman
Senior Member
i apologize , what i actually meant was "Pull" data from sql server.
Re: synchronizing data from sql server [message #647189 is a reply to message #647188] Thu, 21 January 2016 09:37 Go to previous messageGo to next message
Michel Cadot
Messages: 65254
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).

Re: synchronizing data from sql server [message #647213 is a reply to message #647189] Fri, 22 January 2016 11:43 Go to previous messageGo to next message
Michel Cadot
Messages: 65254
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)?

Re: synchronizing data from sql server [message #647217 is a reply to message #647213] Fri, 22 January 2016 21:55 Go to previous messageGo to next message
m.abdulhaq
Messages: 233
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.



Re: synchronizing data from sql server [message #647218 is a reply to message #647217] Sat, 23 January 2016 01:20 Go to previous messageGo to next message
Michel Cadot
Messages: 65254
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Need to schedule


In SQL Server or in Oracle?

Re: synchronizing data from sql server [message #647222 is a reply to message #647218] Sat, 23 January 2016 03:49 Go to previous messageGo to next message
m.abdulhaq
Messages: 233
Registered: April 2013
Location: Ajman
Senior Member
In oracle.
Re: synchronizing data from sql server [message #647223 is a reply to message #647222] Sat, 23 January 2016 03:52 Go to previous messageGo to next message
Michel Cadot
Messages: 65254
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.

Re: synchronizing data from sql server [message #647229 is a reply to message #647223] Sat, 23 January 2016 10:49 Go to previous message
m.abdulhaq
Messages: 233
Registered: April 2013
Location: Ajman
Senior Member
thanks Michael.
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:
  


Current Time: Thu Dec 14 16:02:13 CST 2017

Total time taken to generate the page: 0.05897 seconds