Click here to Skip to main content
15,885,767 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi.
I have 2 database,but very different between tables and fiels tables.
I will every 2 or 5 second data records transfer to other database.
sample:
database A ------------->table1(id,name,family,age,education)
Database B-------------->table2(idpro,product,numer,docum)
*-------------------------------*
table1---TRANSFER EVERY 2 SECOND ----------- table2


THNX
Posted
Updated 28-Mar-15 2:47am
v4
Comments
CHill60 27-Mar-15 6:31am    
What have you tried?
John C Rayan 28-Mar-15 8:48am    
Write your query and run it using SQL Agent in a scheduled job

1 solution

how use from sql server agent jobs/scheduled ?
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900