auto insert data from a database to other database?

[hnptuyen]

Hi all!
Please, help me. Tell me about "auto insert data from a database to other database".
Thanks Very much.
Jimmy Huynh

[Shuja Ali]

Welcome to the Forum :wave:

Would you mind telling us which database you are using? In case of SQL Server you can use schedule a Job to run a DTS package that will insert data from one database to another.

[hspc]

This also depends on the frequency of data updates or insertions and the topology. Replication can also be an option.
So, more details please :)

[bashish]

If you are using Oracle Database, use db-link and triggers.

-Ashish

[DanielaTm]

If you are using SqlServer, you can use a linked server. I used it, it is ok

here is an example:

http://msdn2.microsoft.com/en-us/library/ms188427.aspx