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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-01 : 10:19:09
|
| J mc writes "A potential client has information already stored in a DB and they are asking me can I develop an ASP web application for some specific add-on functionality.I was going to set up a SQL Server 2000 database for the backend of my app but the client has now mentioned that I will need to access information stored on their database e.g. User info. I will need to access their info to, for instance, assign a course (course info will be stored in my DB) to a user.I guess my question is what would be the best way of combining the information. I may need to do join operations so I'll need the info in my local DB, in some shape or form!Should I try and set up some kind of DB synchronisation routine with information from their tables being imported into tables in my DB?Could I try and use the remote DB from a stored procedure i.e. select the remote info into a local temporary table before utilising it. I know there is a USE DATABASE command - does this work for DBs hosted on different boxes?Any help would be greatly appreciated..." |
|
|
|
|
|
Inter-database communication