How to do insertion automatically
-
Hi All, I have two databases Example -A1 and A2, both are linked in SQL Server2008. I am pulling 3 tables information from A1 database and putting it into A2. But I am doing this manually by running the below queries Example : insert into TMP_ITEMS select * from A1..DEX.items How to make this as a automatic process. Thanks, Vidya Sagar
-
Hi All, I have two databases Example -A1 and A2, both are linked in SQL Server2008. I am pulling 3 tables information from A1 database and putting it into A2. But I am doing this manually by running the below queries Example : insert into TMP_ITEMS select * from A1..DEX.items How to make this as a automatic process. Thanks, Vidya Sagar
How about using a trigger on the insert. As each record is inserted into one database, a similar record can be inserted into the other. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
-
Hi All, I have two databases Example -A1 and A2, both are linked in SQL Server2008. I am pulling 3 tables information from A1 database and putting it into A2. But I am doing this manually by running the below queries Example : insert into TMP_ITEMS select * from A1..DEX.items How to make this as a automatic process. Thanks, Vidya Sagar
I've done that with a Windows Service. You could also use a Windows Scheduled Task.
-
How about using a trigger on the insert. As each record is inserted into one database, a similar record can be inserted into the other. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
-
Hi All, I have two databases Example -A1 and A2, both are linked in SQL Server2008. I am pulling 3 tables information from A1 database and putting it into A2. But I am doing this manually by running the below queries Example : insert into TMP_ITEMS select * from A1..DEX.items How to make this as a automatic process. Thanks, Vidya Sagar
You can also check out replication.[^]
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions