copy rows between sql server databases programatically with .NET

Question

I have a website that runs in one server and is used to preview some content. Once the user is happy with it, it needs to be approved and published to the live server. This only implicates copying data from a few tables...

What's the best way of approaching this?

EDIT: I'm using ASP.NET 4, MVC2, SQL Server 2005 on the local server, and SQL Server 2000 in the live one.

Thanks

Robbie Tapping · Accepted Answer · 2011-04-20 11:38:31Z

1

You could use SQL Link Server between SQL 2005 and SQL 2000, in which you can then write a query on the SQL 2005 Instance to transfer the Data to the SQL 2000 instance.

Also you could use ASP.NET ADO Connections and Make a Seperate connection to either server, and use a DataSet to transfer your data through you .NET code between 2 x SQL Functions.

If you are inserting Data into either Database using ADO SQLCommand object, make sure to use Parameters Querys rather than building your query with & or + signs.

answered Apr 20, 2011 at 11:38

Robbie Tapping

2,5561 gold badge17 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

copy rows between sql server databases programatically with .NET

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related