Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combining Multiple DataBases

Status
Not open for further replies.
klewis10367

klewis10367

MIS
Mar 12, 2003
678
US
I have three databases that are exactly the same in structure but hold data for different companies. I want to be able to combine these three databases into 1 database. I can not use replication because it requires me to add a unique indentifier fieled to the source data, which is a no no. I do not want to use union views because I do not want to have to give permissions to the tables that make up the views. I can not you DTS to its fullest because I only want to bring in changed data. Any one have any ideas or know of any software that will do this?
 
Status
Not open for further replies.

Similar threads

Palooka
  • Locked
  • Question
How to *easily* import multiple DTS packages? 1
Replies
3
Views
63
MDXer
MDXer
runner15
  • Locked
  • Question
Running DTS multiple times looping VB
Replies
2
Views
55
runner15
runner15
budgetboy
  • Locked
  • Question
Import Multiple Excel Spreadsheets into an SQL table
Replies
1
Views
32
rodeomount
rodeomount
rodeomount
  • Locked
  • Question
Possible to select multiple fields in a Lookup?
Replies
1
Views
30
fuzzyocelot
fuzzyocelot
fredong
  • Locked
  • Question
Archive databases using DTS ?
Replies
2
Views
29
fredong
fredong

Part and Inventory Search

Sponsor

Back
Top