Data Deploy to SQL Server table with PK as autonumber

Hi,
I’m quite new to TeamSite and OpenDeploy...

The problem I’m facing is what is the best way to deploy data to SQL Server database table that has it's PK set as autonumber?

How do you include this in the dcrs so later can be used for updates and/or deletes?

Is this doable at all?

Any other options...

Thanks in advance!

Find more posts tagged with

Comments

moonkhanna

I think, this should work but did you try the deployment? Are there any error messages you are seeing in the Micro Deployment log? Can you paste the error message you are seeing or just attach the deployment and micro log to your post?

ptgoce

I did try and doesn't work - complains about not been able to populate the ID (PK) field because it is not present in the DCR.

I change the deploy script so it thinks other field is PK (example Name instead of CustomerID) and it does deploy but when you modify that(the Name) field what happens in the database is the old record gets deleted and new one gets inserted – the problem in here is that the old record may have been used as a FK in other table/row... do you see the problem?

So basically, in this example, we can do updates only if we don' change the Name of the customer...

Bill Klish

Read the Advanced Features section of the Data Deploy guide and look for the Get External Data source documentation. You have to write a simple java class that implements an Interwoven defined interface to get this value to show up. It is not needed within the DCR.