Transfering data from one DB server to another DB server using ASP

[Manohar Kamath [MVP]]

If you are talking about SQL Server, use DTS package to transfer data. It
is really elegant that way. You could invoke the package from ASP pages.

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"Anastasios Angelidis" <tassoa@trustmarque.ca> wrote in message
news:602701c357a2$0f2160b0$a001280a@phx.gbl...

> I have a set of data that lies within one DB server and I
> need to transfer that data to another DB server.
>
> Bassically our application is split up as test and live...
> Using Active Server Pages, we initially set up our
> customers on our test servers all the data is stored on
> the test server DB. Our customers have tested the system
> and now wish "Go Live" now we must transfer all the
> initial data from the test DB server to the live DB
> server. We have a tool wriiten in ASP using ADO to
> initailly enter all the data to the test DB server. Now we
> would like to extend our ASP application to have a "Go
> Live" button witch will transfer all the data....
>
> What is the best practice to this?
>
> Thanks

[Anastasios Angelidis]

Yes it is MS SQL Server and that's what exactly am looking
for ;)

Thanks

>-----Original Message-----
>If you are talking about SQL Server, use DTS package to

transfer data. It

>is really elegant that way. You could invoke the package

from ASP pages.

>
>--
>Manohar Kamath
>Editor, .netBooks
>[url]www.dotnetbooks.com[/url]
>
>
>"Anastasios Angelidis" <tassoa@trustmarque.ca> wrote in

message

>news:602701c357a2$0f2160b0$a001280a@phx.gbl...

>> I have a set of data that lies within one DB server and

I

>> need to transfer that data to another DB server.
>>
>> Bassically our application is split up as test and

live...

>> Using Active Server Pages, we initially set up our
>> customers on our test servers all the data is stored on
>> the test server DB. Our customers have tested the system
>> and now wish "Go Live" now we must transfer all the
>> initial data from the test DB server to the live DB
>> server. We have a tool wriiten in ASP using ADO to
>> initailly enter all the data to the test DB server. Now

we

>> would like to extend our ASP application to have a "Go
>> Live" button witch will transfer all the data....
>>
>> What is the best practice to this?
>>
>> Thanks

>
>
>.
>