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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Please Help . make Script Update Automaticly !!

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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.
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/





yea , I want that

Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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 ETL

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/



Go to Top of Page
   

- Advertisement -