scrape data from multiple DB servers into centralized DB

Question

scrape data from multiple DB servers into centralized DB

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

liz-419657 SSC Enthusiast Points: 107 More actions · Answer 1

switching where synonyms point sounds like a great idea. i need to read up on this.

thinking about it some more raised another question:

i will have some kind of process scheduled to trigger the data export (and the process suggested with synonyms). how can i keep track of which table synonym TableA is currently pointing to?

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 2

that these were not GUI applications that were loading these tables, but some sort of machine-driven data entry

Doesn't matter... same idea. Data is being added at a decent rate and probably one row at a time...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 3

how can i keep track of which table synonym TableA is currently pointing to?

How does a database keep track of anything? Table. Create a new table to keep that single row of "configuration" info...

Also, don't forget... the View would only act as a synonym... there are no synonym's in 2k.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

liz-419657 SSC Enthusiast Points: 107 More actions · Answer 4

we are using 2005. so synonym on an updateble table would work. correct?

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 5

Yes... just change the synonym to point to the correct table.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)