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.
| Author |
Topic |
|
fogofogo
Starting Member
11 Posts |
 Posted - 2008-01-15 : 06:55:32
|
| Hello all,I have been asked to work on a database project in work that involves transfering data from a remote database, to our local database. There is already a connection in place between the two databases, so theres no problem with security. The owners of the remote database, have created 3 stored procedures that I must call to update my local database on my local server. So am I correct in saying that I need to use DTS to achieve this? I'm very new to DTS and sqlserver so any advice, and any links to DTS tutorials would be a major help.Thanks for your timeJohn |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-01-15 : 07:16:08
|
| >> So am I correct in saying that I need to use DTS to achieve this?no.You can possibly use a linked server or openrowset - this would be simplest but will depend on the security and might not be fastest.Another option is bcp out and bulk insert in - that would probably be fastest.DTS is more complicated but is a client application (like bcp) which could be useful.==========================================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. |
 |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2008-01-15 : 07:16:55
|
| Not Neccessarily.Look up OPENROWSET and OPENDATASOURCE in BOOKS ONLINE, it can more than likely be achieved just with that.Duane. |
|
|
|
fogofogo
Starting Member
11 Posts |
Posted - 2008-01-15 : 07:26:27
|
| thats cool! thanks. I'll start with your suggestions. |
|
|
|
|
|
|
using dts