I am trying to create column to column mapping between the databases. Only certain data will be transfer bepending on conditions. Also the mapping will change depending on conditions. This proc would be dynamic enough that it would handle all possible conditions and then make the correct column mapping and data transfers. I am not sure if you can do this with DTS.
I might be able to do this with replication, but i thought the proc would be the best method since I am not trying to move data across servers, only across databases.
I have created procs similiar to this using Unix scripts, between two sybase databases, however it seems SQL server does not like the syntax.
Originally posted by mtracey
Have you taken a look at DTS or maybe replication ? DTS would be a place to start.