I have what I am hoping is a simple question...
I have to update an older version of our database schema to our new structure (that part was easy), then I have to copy the old data to the new tables. For some of the data I was able to generate my own mappings so I did not overwrite current data or lose legacy data.
So far so good.
I do have a couple of tables that have me stymied. To simplify things the table looks like this:
ID (identity) | CallID (our software generates this and needs to be unique)
The problem is I need to ensure that although there will be DUPLICATE CallID's across the tables - I need NEW CallID's for the old.
Can this be done within the SDK?
Should I just build the SQL by hand and do it that way?
Thanks for the help!