Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

Faced some problem in sql and oracle

0

33 views
  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 and oracle server database
asked June 23, 2011 9:18 pm CDT
posted via StackOverflow

1 Answers

0
Best answer
 

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/

answered June 24, 2011 9:16 am CDT

Your answer

Join with account you already have


Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Liferay and Oracle DB
March 14, 2011
Mysql to oracle
March 16, 2011
Mysql over Oracle..
February 13, 2011
Oracle Scalability
April 5, 2011
Oracle access from iOS
January 4, 2011
Oracle (RAC) vs NoSQL
February 9, 2011
SQLite to Oracle
March 4, 2011