Can I syn Oracle DB to SQL server
-
I am wondering if I can syn some table, views, some record such as select some from table where what I like from oracle DB to my SQL server. Thanks.
-
Assuming "syn" means "sync", or you want to get some data from an Oracle database to a SQL Server database then have a look at this Connecting SQL Server and Oracle Using Linked Servers | SQL Server content from SQL Server Pro[^]
-
Thanks so much.I Know this solution, I have linked the server but the problem is Oracle DB is a big DB, I only want to syn some data only depend on my need.So that the DB is smaller and the website will run quicker.
So write some queries to extract only the data you require. You can set up Tasks to make this happen on a regular basis - see Schedule a Job[^] Note that a "smaller DB" does not necessarily mean that it will be quicker, much depends on the database design, indexes used, and efficiently written queries for example.
-
So write some queries to extract only the data you require. You can set up Tasks to make this happen on a regular basis - see Schedule a Job[^] Note that a "smaller DB" does not necessarily mean that it will be quicker, much depends on the database design, indexes used, and efficiently written queries for example.
OK I Know the schedule job.I Can get everything i want to get.But this is only get data not syn data.At the 8 am everyday i get data I need yesterday.But if there is some error that need to run some procedure to update the source oracle DB and they don't tell me.I don't have exactly the data I need.That why i ask for syn tool
-
OK I Know the schedule job.I Can get everything i want to get.But this is only get data not syn data.At the 8 am everyday i get data I need yesterday.But if there is some error that need to run some procedure to update the source oracle DB and they don't tell me.I don't have exactly the data I need.That why i ask for syn tool
I'm sorry you've lost me. What is "syn data" If you mean "sync" then you can have oracle "publish" the data changes - see Create a Publication from an Oracle Database[^] There are also plenty of synchronisation tools out there, some of which are very expensive. Personally, I would just get the data from the original source - as I said earlier you are not necessarily going to get your website to "run quicker" by doing this. It's more likely that it's the way you are getting the data that requires tuning
-
I'm sorry you've lost me. What is "syn data" If you mean "sync" then you can have oracle "publish" the data changes - see Create a Publication from an Oracle Database[^] There are also plenty of synchronisation tools out there, some of which are very expensive. Personally, I would just get the data from the original source - as I said earlier you are not necessarily going to get your website to "run quicker" by doing this. It's more likely that it's the way you are getting the data that requires tuning