Save to a table in another DB while executing application on another DB

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I need a help on the below situation,please..

I am working with ASP.net C# application which is connected to sql 2008 R2 with a DB say myTestDB. My application is inserting ,updating and deleting on the tables in this DB.

Now I need to implement a logic in which on certain conditions, the data will get saved to a table in another DB -say mySecondDB

I came to know that we can either handle different connection string in the web.confing to the "mysecondDB" and connect

or i can handle in the back end (SQL) by insert inti mysecondDb.dbo.tablename

I don't know any other option we can use.

Please advise the optimum and fast method for doing this.

Thanks in advance..

Posted 19-Mar-15 0:24am

Member 10112611

Add a Solution

1 solution

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)

Joan Magnet · Accepted Answer · 2015-03-19T00:37:00

Solution 1

Solution 1:

Do not use database.owner.object in your procedures, use only owner.object and let the connection to select the database. Then you can easily change SqlConnection before calling the procedure.

Solution 2:

If you like to have a copy of your database use a replica, and set the replication rules in the database server.

Posted 19-Mar-15 0:37am

Joan Magnet

Comments

Member 10112611 19-Mar-15 6:42am

you mean to define the connection string in c#code ? Not replica.. I have to save some data to another DB based on the interface selection

Joan Magnet 19-Mar-15 6:47am

Yes, you can have two or more connections and use one of them depending on some conditions. Same procedures, different database.

Our intranet works this way.

Member 10112611 19-Mar-15 6:51am

Thanks a lot...mine is web application.. I am worried about the perfomance. hope it will be faster compared to using database.owner.object in your procedures ...