Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
iwaters
Starting Member
13 Posts |
 Posted - 2005-08-10 : 09:41:56
|
| I have an existing application which has been in use for some time. I have now been asked to create another application which will include some of the data from the other application. This will not always be the case though which is why the two applications are seperate.What is the best way to structure the second application so the data that is shared can be entered once, but accessible in the relevant records in both applications and remain acurate in both? If possible I don't want to have to change the existing application drastically.Any ideas? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-08-10 : 09:46:40
|
you could create a new db and simply access the old db from the new with select * from dbname..tablenamethat way the data you want in both apps is in one place.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
Connecting Multiple Datasets