Replication or DTS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Replication or DTS

Author

Topic

alo
Starting Member

6 Posts

Posted - 2003-06-04 : 08:29:04

Hi,

Here is a need to get remote data(mssql-2000) to a local database(mssql-2000) on daily basis. Having known server, database, user id, password at both ends, which service should i use and how to use? Please spare ur valuable time since i need it urgently.

Thanks.

Alo

Edited by - alo on 06/04/2003 08:38:12

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-06-04 : 08:39:18

The appropriate solution depends on the requirements. Is this a one time thing or something that needs to happen on a regular basis? What kind of frequency? Once a day? Real-Time?

Replication is going to be a more complicate solution.

Jay White
{0}

nr
SQLTeam MVY

12543 Posts

Posted - 2003-06-04 : 11:02:57

And why restrict yourself to replication and dts?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

X002548
Not Just a Number

15586 Posts

Posted - 2003-06-04 : 13:12:18

link the server? sp_addlinkedserver?

Brett

8-)

GWilliy
Starting Member

1 Post

Posted - 2003-06-05 : 01:21:14

Is the Local Server going to be read Only ?

What kind of connection do you have ?

There are a number of ways to achieve this kind of thing - but you need to provide more info so that you choose the right one.

Snaphot Replication is quite reliable and maint free once set up.

DTS is made for this type of thing.

Linked servers are sufficient for Basic operations - But are harder to program and less reliable if you need to do more in the future.

You can even dump data to a Text File & email it.

etc etc.

GW

alo
Starting Member

6 Posts

Posted - 2003-06-06 : 03:05:26

Hi,

Thanks for ur reply. the frequency for this service is as and when needed. i mean that whenever the remote data is needed at the local end it has to get the data.

With Thanks,
alo

quote:

The appropriate solution depends on the requirements. Is this a one time thing or something that needs to happen on a regular basis? What kind of frequency? Once a day? Real-Time?

Replication is going to be a more complicate solution.

Jay White
{0}

alo
Starting Member

6 Posts

Posted - 2003-06-06 : 03:09:57

Hi,

Thanks for ur words, if u dont mind could u explain the steps needed to use cursors to get done this service?

With Thanks,
alo

quote:

And why restrict yourself to replication and dts?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

alo
Starting Member

6 Posts

Posted - 2003-06-06 : 03:17:04

Hi,

Thanks for ur kindful reply.
Local server is to be read only
Database connection - OLEDB Connection
Net - Dial up internet connection

said these, which is the best option? could i get the steps to get done the best option? greateful to u on getting ur knowledge

With Thanks
alo

quote:

Is the Local Server going to be read Only ?

What kind of connection do you have ?

There are a number of ways to achieve this kind of thing - but you need to provide more info so that you choose the right one.

Snaphot Replication is quite reliable and maint free once set up.

DTS is made for this type of thing.

Linked servers are sufficient for Basic operations - But are harder to program and less reliable if you need to do more in the future.

You can even dump data to a Text File & email it.

etc etc.

GW

alo
Starting Member

6 Posts

Posted - 2003-06-06 : 03:20:12

Thanks a lot.
if u dont mind could u send me the steps to get done this service.

With Thanks,
alo

quote:

link the server? sp_addlinkedserver?

Brett

8-)

X002548
Not Just a Number

15586 Posts

Posted - 2003-06-06 : 09:37:21

quote:

Hi,

Thanks for ur words, if u dont mind could u explain the steps needed to use cursors to get done this service?

With Thanks,
alo

quote:

And why restrict yourself to replication and dts?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Nigel, please tell him you're kidding!

Cursors...Nooooooooooooooooooooooooooooooooooo

(but they do have their place...but don't let that get out)

Brett

8-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources