| Author |
 Topic  |
|
|
AMCSQL
Starting Member
3 Posts |
 Posted - 01/31/2013 : 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
India
47157 Posts |
Posted - 01/31/2013 : 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 MVP
http://visakhm.blogspot.com/
|
 |
|
|
srimami
Posting Yak Master
152 Posts |
Posted - 01/31/2013 : 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 - 02/01/2013 : 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 MVP
http://visakhm.blogspot.com/
yea , I want that
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47157 Posts |
Posted - 02/02/2013 : 01:44:34
|
how frequently you want to sync up values? is tables having insert alone or updates can also happen?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1770 Posts |
Posted - 02/02/2013 : 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 ETL
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
|
AMCSQL
Starting Member
3 Posts |
Posted - 02/02/2013 : 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 MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
Please Help . make Script Update Automaticly !!
