Re: data update suggestions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I guess you should start with estimating amount of data being transfered, it
frequency and concurrency requirement.
the more data and more frequent and how fast you have to be "in sync"-
replication is most likely scenario you should go with. Less data and less
frequent - a custom app or SSIS package might do the trick...

"Sas" <Sas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0F14BBEA-A720-40FF-88A3-8C7B126DBC46@xxxxxxxxxxxxxxxx
We have production database (1TB, sql server 2005) and we will receive
daily
updates from a vendor. All the updates will be imported in another
database
first (source db). What would be the best way to apply the updated
information to the from the source DB to the production DB (example of
updates are: new products or just price changes on existing products
etc....). I was thinking about unidirectional merge database (src db to
prod
db) but if someone can give some suggestions it would be greatly
appreciated!

Thank you all
--
--
System Engineer
MSc in CS, MCSE4, IBM Certified MQ 5.3 Administrator
"I saw it work in a cartoon once so I am pretty sure I can do it."


.

Relevant Pages

  • Re: data update suggestions
    ... Why are you using merge when the data flow is in one direction. ... frequent - a custom app or SSIS package might do the trick... ... All the updates will be imported in another ... I was thinking about unidirectional merge database (src db to ...
    (microsoft.public.sqlserver.replication)
  • Re: Pictures on ABPW?
    ... It's not as nice as my previous provider (retention is shorter and updates ... are less frequent) but it is perfectly adequate and the price is right. ... you get lifetime access with a download ratio of ...
    (rec.woodworking)
  • Re: Locking up when editing addresses
    ... Entourage is working just fine until I edit addresses in the To: ... frequent causes the whole system to lock up. ... Combo updates often fix strange OS problems because they overwrite files ...
    (microsoft.public.mac.office.entourage)
  • Re: Newsreaders
    ... I didn't even read Jake's original message about frequent ... > updating as a complaint. ... > will start contributing more when the frequency of updates slows down. ...
    (borland.public.delphi.non-technical)
  • File Write / possible failure/corruption
    ... we have developed an application(a simple database) that does frequent ... read-writes to files on PocketPC. ... Is it possible that the write on a file fails without write returning an ...
    (microsoft.public.windowsce.app.development)