Now the customer wants to do an interface that will need daily sqlsever in some new business data import to view the several tables in an oracle database, the key also regularly run automatically every day, to be able to achieve unattended... Idea is to view before export into XML or TXT, then import, but don't know how to do that run automatically, development with pb9.0, what are the appropriate function can be used?
Give some other Suggestions or a great god, as long as can meet customer requirements!
CodePudding user response:
Set up the main program timing interval time (num), set the interval to perform in PB window timer events, write down sqlinsert into the select * from A to B etc.
If it is a SQL database, you can do with the job in the background
CodePudding user response:
Windows program task
And then there is the Timer ()
And then there is more time
No you don't have to schedule a task, direct timing boot, boot to run automatically, just finished directly automatic shutdown
CodePudding user response:
Set up the main program timing interval time (num), set the interval to perform in PB window timer events, write down sqlinsert into the select * from A to B etc.
If it is a SQL database, you can do with the job in the background
CodePudding user response:
If the SQL and ORACLE can be connected to each other, why not use the JOB?
CodePudding user response:
reference 1st floor wz19870429 response: set up the main program timing interval time (num), set the interval to perform in PB window timer events, write down sqlinsert into the select * from A to B etc. CodePudding user response:
PB with different transaction connecting two different database, through the timer () to control events trigger time, and then put the needed data retrieved to datasotre, data written to a connection oracel datastore again, and then save the data, CodePudding user response:
refer to 6th floor smilysoft response: Plain Text code? 1 pb with different transaction connect two different database, through the timer () to control events trigger time, and then put the needed data retrieved to datasotre, data written to a connection oracel datastore again, and then save the data, CodePudding user response:
refer to 6th floor smilysoft response: Plain Text code? 1 pb with different transaction connect two different database, through the timer () to control events trigger time, and then put the needed data retrieved to datasotre, data written to a connection oracel datastore again, and then save the data, CodePudding user response:
refer to 6th floor smilysoft response: Plain Text code? 1 pb with different transaction connect two different database, through the timer () to control events trigger time, and then put the needed data retrieved to datasotre, data written to a connection oracel datastore again, and then save the data, CodePudding user response:
references 9 f xiaoqiangsweet response: refer to 6th floor smilysoft response: Plain Text code? 1 pb with different transaction connect two different database, through the timer () to control events trigger time, and then put the needed data retrieved to datasotre, data written to a connection oracel datastore again, and then save the data, CodePudding user response:
references to the tenth floor smilysoft response: references 9 f xiaoqiangsweet response: refer to the sixth floor smilysoft response: Plain Text code? 1 pb with different transaction connect two different database, through the timer () to control events trigger time, and then put the needed data retrieved to datasotre, data written to a connection oracel datastore again, and then save the data, CodePudding user response:
Every day will be a few sqlsever view new business data import to an oracle database CodePudding user response:
If it is run automatically, no need to pb, directly on the Oracle or used automatic homework, timing to extract data, efficiency is tall, script modification is convenient, CodePudding user response:
Used with automatic perform administrative tasks (SQL Server agent); CodePudding user response:
Need not so difficult, you can create two connection, even the two databases at the same time, and then use code to write, have what difficult 