IS their any other service like linked server to transfer data from Local DB to Production DB

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I tried linked server to transfer data from local db to production db

It runs ok but has some issue
1: Performance : Linked server query takes too much time to perform.

for ex :select * from server1.udupikrishna.dbo.emp1

above query takes too much time to get dataset.

IS their any other service like linked server to transfer data from Local DB to Production DB

i am not doing transfer only once .. And also want to implement it in ASP.net project..So searching for different service which can easly done through asp.net

Posted 27-Mar-13 9:55am

k@ran

Updated 27-Mar-13 10:10am

v3

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)

**Zoltán Zörgő** · Answer 1 · 2013-03-27T10:06:00

Solution 1

1) Your performance depends on many things.
2) For transferring data between two remote databases you have some options, like this using the SQL Management Studio data import and export features: http://msdn.microsoft.com/en-us/library/ms140052.aspx[^]

[Update]
If you check the link, you will notice, that you can configure the same data transfer as SSIS package task. You can read in this article[^] how to run such a package from asp.net.

Posted 27-Mar-13 10:06am

Zoltán Zörgő

Updated 27-Mar-13 10:16am

v2

Comments

k@ran 27-Mar-13 16:09pm

But i am not doing transfer only once .. And also want to implement it in ASP.net project..So searching for different service which can easly done through asp.net

Zoltán Zörgő 27-Mar-13 16:10pm

I doubt you have read the link. You can make SSIS package too, not only interactive transfer.

k@ran 27-Mar-13 16:38pm

I have configureg my application in local intranet. so there i need some client requirement to move some secure data from local db to production daily..

Zoltán Zörgő 27-Mar-13 16:39pm

Ok, and that excludes SSIS?

k@ran 27-Mar-13 16:42pm

Using SSIS i am not able to fullfill my requirement as it moves all data . As i have to upload data from local and after sucessiful uploading i want to delete that information from local.

Is there any Stored procedure or anything else to achieve my goal please help ..

Zoltán Zörgő 27-Mar-13 16:49pm

Well, be a little bit more ingenious, and make a prefilter on source side: copy to a local (temporary) table the data you want to transfer remotely. It will be fast, and you can overcome this problem. But this problem does not exist at all, since you can use a query and you don't nee to transfer a whole table at all.
But if you ask of stored procedure in this topic, than you have other problems...
You have an other option, which you will find even less interesting (even being a good one in several situations): export to a common format, copy over network and import on the other side.

k@ran 27-Mar-13 16:59pm

thanks Zoltán Zörgő for your support ..

Maciej Los 27-Mar-13 17:03pm

Nice, +5!

Zoltán Zörgő 27-Mar-13 17:06pm

Thank you.