Call Mutiple DB stored procedures from visual studio

Question

1.00/5 (1 vote)

See more:

, +

Hello ,

I am working on Asp.net website and SQL DB, For Security reasons we are keeping different database for each customer. Now problem is DB objects like Stored Procedures, Views is replicated for each database. If I want to alter any SP ,views or table then I have to do it in all DB's. Is there any way that If I integrate that objects in visual studio and If I change in visual studio it will effect in all DB's.

Posted 16-Feb-15 3:20am

RAHUL(10217975)

Add a Solution

Comments

Kuthuparakkal 16-Feb-15 10:46am

Have you looked at Replication ?
https://msdn.microsoft.com/en-us/library/ms146892.aspx

3 solutions

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)

deepakdynamite · Answer 1 · 2015-02-25T01:38:00

I had same kind of scenario.. But After doing this manually for 3-4 times, I developed an small win form application which will fetch list of databases from one centralized database and will execute scripts on each table... **Note: I created that application for my purpose.. I never gave it to my client of end client.

Lolo1986 · Answer 2 · 2015-02-16T12:25:00

From my understanding you are in SAAS environment. Where I am working right now with have 70+ databases with the same schema, sp, tables... So what you should do is having one common project (cleintProject) and deploy your project against the different clients. So you will maintain only one version of your code that will be deployed on all your DB. If you have some specific code for a client you can still use create it in this solution knowing that it will be used only by this guy.

Hope it will help you.

Joan Magnet · Answer 3 · 2015-02-25T01:58:00

Solution 3

I use ApexSql Diff to do this job.

It' really useful, maintain one and replicate to all.

ApexSql Diff

Posted 25-Feb-15 1:58am

Joan Magnet

Call Mutiple DB stored procedures from visual studio

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0