copy data from one database to another database

Hi,

I'm not sure if it is the right place to ask this question.
Anyway, we had a Window NT service written in VB to
automatically copy data from one SQL server db to another
SQL server db hourly. I would like to know what is the
best way to implement this task in .net framework. Windows
service? There are any VB.net samples code for this?

Thanks in advance.
tom

Girish
Wed Oct 22 08:28:37 CDT 2003

tom wrote:

> Hi,
>
> I'm not sure if it is the right place to ask this question.
> Anyway, we had a Window NT service written in VB to
> automatically copy data from one SQL server db to another
> SQL server db hourly. I would like to know what is the
> best way to implement this task in .net framework. Windows
> service? There are any VB.net samples code for this?
>
> Thanks in advance.
> tom

Why not use either REPLICATION feature of SQL server or DTS ervices?

--
Girish Bharadwaj

S
Wed Oct 22 13:51:51 CDT 2003

Hi There

The best bet would be to use snapshot / merge replication
provided by SQL Server

The following link will be helpfull

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8825

Thanks,
Gopi
>-----Original Message-----
>Hi,
>
>I'm not sure if it is the right place to ask this
question.
>Anyway, we had a Window NT service written in VB to
>automatically copy data from one SQL server db to
another
>SQL server db hourly. I would like to know what is the
>best way to implement this task in .net framework.
Windows
>service? There are any VB.net samples code for this?
>
>Thanks in advance.
>tom
>.
>

Dino
Mon Oct 27 15:03:40 CST 2003

With DTS you can build a transfer job and schedule it.
So simple!
no programming.


"S Gopikrishna" <anonymous@discussions.microsoft.com> wrote in message
news:02df01c398cd$8de1f7e0$a301280a@phx.gbl...
> Hi There
>
> The best bet would be to use snapshot / merge replication
> provided by SQL Server
>
> The following link will be helpfull
>
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8825
>
> Thanks,
> Gopi
> >-----Original Message-----
> >Hi,
> >
> >I'm not sure if it is the right place to ask this
> question.
> >Anyway, we had a Window NT service written in VB to
> >automatically copy data from one SQL server db to
> another
> >SQL server db hourly. I would like to know what is the
> >best way to implement this task in .net framework.
> Windows
> >service? There are any VB.net samples code for this?
> >
> >Thanks in advance.
> >tom
> >.
> >