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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to forward database request between 2 DBs

Author  Topic 

vondiplo
Starting Member

8 Posts

Posted - 2008-12-13 : 10:30:30
Hello All,
Sorry for the lengthy post, wanted to make my question as clear as possible. feel free to jump to the bold part ;)

I'll describe my situation:
I'm currently working on a small project at home. I've got two computers:
The First : Holds an instance of sql server installed on it
The Second: Holds my web application along with the BL and DAL

Currently it works fine for me, I give the second computer a connection string to the remote DB and I am satisfied. Though, a friend of mine joined the project and he wishes to be able to work from his home. So I've installed a version control (Svn) on the second computer,so he can download the files straight to his computer, change them and commit his updates.

Now, I wish him to be able to do two thing:
1. Connect to the SVN client, download and update the source files
2. Run the application he downloads to his own PC and test it (against my DB)

The problems here is the fact that I am using a router (therefore I am firewalled). I can forward his request to only one of the computers, and I'd rather forward him to the SVN client rather than to the DB. I cannot install both the DB and the SVN client on the same PC.

I do have another instance of sqlserver running on the second computer. So I've been thinking that a good solution would be to ask the DB to froward the request to another, remote DB. Is it possible? How do you do that?


Thank you very much for your help!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-13 : 22:20:38
I'm not clear on what your SQL Server question is. What do you mean by forward the requested to another database?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -