Build a Web Interface to transfer DATA between Sql servers 2005

Hello,
I would like to know if there is any SDK i can use to build a WebPage
which would enable me to transfer data between sql servers.
Purpose: Non technical people who are not familiar with using
administrative managers, would like to have a publish button where by
they can publish/move data from staging to production. Usually its done
via DTS, but they will not be able to handle DTS.
thanksIs linked servers an option? You didn't specify a language for your
project, but if it's ASP.NET what about just opening up two SqlConnections
to the two different servers and coding SELECTs from one and INSERTs/UPDATEs
into the other? There are a lot of options, but without more specifics it's
hard to say what would be useful for you...
"tillu" <tillu77@.gmail.com> wrote in message
news:1147818011.964849.297580@.j55g2000cwa.googlegroups.com...
> Hello,
> I would like to know if there is any SDK i can use to build a WebPage
> which would enable me to transfer data between sql servers.
> Purpose: Non technical people who are not familiar with using
> administrative managers, would like to have a publish button where by
> they can publish/move data from staging to production. Usually its done
> via DTS, but they will not be able to handle DTS.
> thanks
>