Click here to Skip to main content
12,956,606 members (76,034 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I don't know am i asking a stupid question or wat?

Is that possible ornot, if try select data from 10 different databases and those grabbed data will be insert into the main database?!

what i mean is 10 database link to 1 main database is that possible?
Posted 15-Jan-13 16:23pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Anything is possible. (Other than the Cubs winning the Series.)

Are you looking for an ETL package? What databases? My whole last year has been spent writnig SSIS packages to copy data from a lot of databases (Oracle, MySQL, etc.) into one SQL Server database.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

k look at your reply, seem possible and you experience before,

(my scenario is e.g. i got 10 branches local small workstation with small database installed and now i want to do linkage between the 10 small databases and the main headquarter database)

just want to ask you, how to fix the mapping of those databases directory? *for declaring connection string purpose.

is that i have to touch about track ip addresses?
PIEBALDconsult 15-Jan-13 23:14pm
You should have made that a question or comment; not an answer, please learn to use the site.

If you are using SQL Server (and you didn't answer my question) then perhaps you are looking for replication. I've never used replication, so it may not be what you want.

You may also want to look into having a Web Service at the headquarters that the remote systems would use to send their data.

Something you definitely need to allow for is lack of connectivity.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,869
CHill60 3,550
Maciej Los 3,302
ppolymorphe 2,080
Jochen Arndt 1,973

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 15 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100