I am using SalesLogix (on SQL db ) and am about to push out a new sales engine I created. My only problem now is I have created a new table structure and need to move all the old data into the new tables. Some columns have changed and some data will be merged intio newly created fields. This shouldn't be too hard. I've tried using DTS in enterprise manager however I can't quite figure out how to get it to do what I want. It wants to create brand new tables when all I want to do is copy data to my already created tables. I'd like to do this without having to spend my (like buying scribe). You can see how non-complicated my table srtucture is below:
P.S. SQL statments would take forever if I had to write a statement for each field as there is at least 40 fields in the sales table alone.
Here are the tables I currently have in a sort of tree view based on joins.
'OLD TABLE LAYOUT
-Mailing (there is really only one record per sale) <-- I know it was pointless but...
-Shipping (Same with the mailing - only one shipping record)
'NEW TABLE LAYOUT
-SALE (which includes mailing and shipping now plus some concatination on some fields)
So you can see I consolidated the Shipping and Mailing tables into the Sale table. Is there some free utility out there that allows you to simply map fields between two or even the same database?