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 |
|
srucker
Starting Member
26 Posts |
 Posted - 2009-01-14 : 15:07:38
|
| What might the comparison of DBLink be in transact sql.I am looking to select a bunch of data from DB A and insert the records to DB B |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-01-14 : 15:08:40
|
| is it just a one time thing or you want to do it on a regular basis? |
 |
|
|
srucker
Starting Member
26 Posts |
Posted - 2009-01-14 : 15:09:29
|
| monthly |
|
|
|
srucker
Starting Member
26 Posts |
Posted - 2009-01-14 : 15:11:18
|
| I am looking write a stored procedure that will do this and have it run monthly |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-01-14 : 15:11:48
|
| create a db link or do it in SSIS |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 15:30:06
|
| There are lots of post regarding this issue. Search in here. |
|
|
|
|
|
|
linking databases