Faced some problem in SQL Server and Oracle [closed]

开发者_如何学JAVA It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

1. My current system is retrieve data from SQL Server and insert into Oracle server every 6 hours. I use own program to do this process. I want to remove the 6 hours gap, mean I hope the data can insert into 2 side at the same time, how can I do it?
2. How can I export part of the data from the database to Pdf, excel and text file format when new data insert
3. I want to know any new database backend software that can help me to manage data in SQL Server and Oracle server database

---

1) You can use SQL server Replication service with Oracle but maybe you have to make some schema changes for replication to work.

Read more http://msdn.microsoft.com/en-us/library/ms152481(v=SQL.90).aspx

2) To export data you can use SQL server Integration Services, make a package that will run a query against the database and export to file. You can also use reporting services with scheduling.

3) You can use each softwares management tool or you can find or buy other software like Toad http://www.toadworld.com/