DTS - Data Transformation Services
-
Hy I have 2 databases and one table for each of database. The tables have the same structure. One of them is populate and I want to copy the contain of this to the second table. I want to ask if this is possible with DTS. thx
mihksoft wrote:
I want to ask if this is possible with DTS.
Yes, better ask in the SQL messageboard though. IMO you will be better off using a simple cross database INSERT/SELECT if they are running on the same instance (that said, copy/paste should work too from within VS).
xacc.ide
The rule of three: "The first time you notice something that might repeat, don't generalize it. The second time the situation occurs, develop in a similar fashion -- possibly even copy/paste -- but don't generalize yet. On the third time, look to generalize the approach."