Click here to Skip to main content
11,705,052 members (50,724 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
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
good
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.
  Permalink  
Rate this: bad
good
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?
  Permalink  
Comments
PIEBALDconsult at 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
0 Sergey Alexandrovich Kryukov 609
1 OriginalGriff 439
2 Andy Lanng 215
3 CPallini 202
4 F-ES Sitecore 160
0 OriginalGriff 8,958
1 Sergey Alexandrovich Kryukov 8,276
2 CPallini 5,189
3 Maciej Los 4,726
4 Mika Wendelius 3,606


Advertise | Privacy | Mobile
Web03 | 2.8.150819.1 | Last Updated 15 Jan 2013
Copyright © CodeProject, 1999-2015
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