Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rijo
Starting Member
8 Posts |
 Posted - 2008-06-03 : 18:06:30
|
| Hi All,I am Currently doveloping a Asp.Net application.I Need to Use two databases one is Sql server and another one is Oracle.My Primary database is Sqlserver . But I need to get data from two tables from the oracle database also. I would like to create the same table in Sqlserver and Update data from oracle (synchronize) automaticaly .Is there any way to syhcronize these table to get the uptodate data.What is the best solution to solve this situation.Please show me example code.By sqlserver way or .Net way Please Help me .Thanks youM.S |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 18:33:38
|
| Yes, you can sync table between them with replication or via linked server. |
 |
|
|
rijo
Starting Member
8 Posts |
Posted - 2008-06-04 : 10:36:30
|
| Could you please explain how can i do that?ThanksMs. |
|
|
|
|
|
|
Oracle ,Sqlserver table sychronization