SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Please Help . make Script Update Automaticly !!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AMCSQL
Starting Member

3 Posts

Posted - 01/31/2013 :  01:30:31  Show Profile  Reply with Quote
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
52309 Posts

Posted - 01/31/2013 :  04:16:44  Show Profile  Reply with Quote
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 - 01/31/2013 :  04:52:04  Show Profile  Reply with Quote
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 - 02/01/2013 :  23:55:25  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 02/02/2013 :  01:44:34  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2008 Posts

Posted - 02/02/2013 :  02:45:39  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 02/02/2013 :  05:02:04  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000