integrate data of some DB into ome, how to?
-
hi i have a program with c# and sql server 2005. i should install it on some stand_alone computers. For reporting i need to integrate these DB's data into one DB. I need a simple solution for a simple user to do that. could you give me a solution???
-
hi i have a program with c# and sql server 2005. i should install it on some stand_alone computers. For reporting i need to integrate these DB's data into one DB. I need a simple solution for a simple user to do that. could you give me a solution???
hs_rostami wrote:
could you give me a solution
No There is no simple solution, either designed you application incorrectly or are in way over your head. You need to look into Replication or data wharehousing (although I doubt this applies) and your data need to be structured to support integrating it into 1 DB.
Never underestimate the power of human stupidity RAH
-
hi i have a program with c# and sql server 2005. i should install it on some stand_alone computers. For reporting i need to integrate these DB's data into one DB. I need a simple solution for a simple user to do that. could you give me a solution???
hs_rostami wrote:
For reporting i need to integrate these DB's data into one DB. I need a simple solution for a simple user to do that.
Simple users aren't allowed near the database. Your easiest way out is to include an extra field in each table, called "DatabaseName". Next, change every sql statement to only update the data where that field matches your current client. It's not optimal, but it would allow for multiple databases to be stored in a single database-file.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
hs_rostami wrote:
For reporting i need to integrate these DB's data into one DB. I need a simple solution for a simple user to do that.
Simple users aren't allowed near the database. Your easiest way out is to include an extra field in each table, called "DatabaseName". Next, change every sql statement to only update the data where that field matches your current client. It's not optimal, but it would allow for multiple databases to be stored in a single database-file.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
I have the same database on different computers, with different raw data of any department, but structures and tables are the same. i have no network, i wanna bring these data toghether for reporting. for example I have these DB's: database 1 : person1 , persson2 database 2 : person3 , persson4 database 3 : person5 , persson6 and I need this for reporting: General Database: person1 , persson2, person3 , persson4, person5 , persson6
-
I have the same database on different computers, with different raw data of any department, but structures and tables are the same. i have no network, i wanna bring these data toghether for reporting. for example I have these DB's: database 1 : person1 , persson2 database 2 : person3 , persson4 database 3 : person5 , persson6 and I need this for reporting: General Database: person1 , persson2, person3 , persson4, person5 , persson6
Same applies; if you had a field called "database", you could drop them all in the same structure. Small example; EmplyeeTable
Id Name OtherStuff
1 John Blabecomes; EmplyeeTable
Id Name OtherStuff Database
1 John Bla Customer1That way you could select everything from that customer, even if there's more than one customers data.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]