Possibility of get data from numbers of databases and store back to main database~!

Question

0.00/5 (No votes)

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

donaldliaw87

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

PIEBALDconsult · Answer 1 · 2013-01-15T16:46:00

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.

Posted 15-Jan-13 16:46pm

PIEBALDconsult

donaldliaw87 · Answer 2 · 2013-01-15T17:05:00

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?

Posted 15-Jan-13 17:05pm

donaldliaw87

Comments

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.