May 21, 2006 at 9:25 pm
A very handy DTS option in 2000 was the ability to copy one or more objects - structure *and* data in one fell swoop. I often have the need of copying a small subset of tables (4-5 tables of 350) from one database to another - structure and data (and, no select ... into won't work becuase it doesn't carry over the constraints). I've spent half a day trying to figure out any way to do this in 2K5. The best I could come up with is a 4 step process that is very cumbersome. Any idea what happened to this very cool feature of 2K? Is it buried somewhere in 2K5? Hopefully? Any ideas would be most appreciated.
TIA!
-kelly
May 23, 2006 at 6:38 am
SSIS has a "Transfer SQL Server Objects" task that is similar.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply