Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AMCSQL
Starting Member
3 Posts |
 Posted - 2013-01-31 : 01:30:31
|
| hello , really I need Help I have Database On SQL Server 2008 , And I want Update All records in this database from anther database ON db2 . I want to do Script work Daily ON time Or when i Want Update , do that manual from this script .HOW CAN I DOOOO THAT !!!!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-31 : 04:16:44
|
| your explanation doesnt make any sense. DO you mean to say you've corresponding tables in two databases and need to sync up their values daily?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-01-31 : 04:52:04
|
| Like Visakh said, it doesn't make sense. What is that you want to update......Database or underlying tables in a database. If you want to update tables, specify what tables and on what basis? Anything related to incremental update? Please be clear. |
|
|
|
AMCSQL
Starting Member
3 Posts |
Posted - 2013-02-01 : 23:55:25
|
quote:
Originally posted by visakh16
your explanation doesnt make any sense. DO you mean to say you've corresponding tables in two databases and need to sync up their values daily?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
yea , I want that |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-02 : 01:44:34
|
| how frequently you want to sync up values? is tables having insert alone or updates can also happen?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-02-02 : 02:45:39
|
| As you're syncing from db2 to SQL Server , and depending on the nature of the data , you many need to consider placing the data first in a staging table , do some transformations and then run the DML , as part of the one ETLJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
AMCSQL
Starting Member
3 Posts |
Posted - 2013-02-02 : 05:02:04
|
quote:
Originally posted by visakh16
how frequently you want to sync up values?I want To Make This 2 time in the day is tables having insert alone or updates can also happen?i don't understand you , but i want update all the values in the table ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
|
|
|
|
|
Please Help . make Script Update Automaticly !!