Activity overview
Latest activity by rel
Is there a way to query the destination database in the filter? For example: modid IN (SELECT modId FROM tContent WHERE sitename = 'abc' and type='plugin') AND modId NOT IN (SELECT modId FROM [destinationDatabase].[dbo].[tPlugins]) Note, I can't create a linked server from the source database to the destination database / comments
Is there a way to query the destination database in the filter?For example:modid IN (SELECT modId FROM tContent WHERE sitename = 'abc' and type='plugin') AND modId NOT IN (SELECT modId FROM [desti...
After all that I just realised tContent is NOT identical in both db's. I'm very sorry about that, I totally messed up that piece of information. I confused myself, it's NOT the same because at the same time the tplugins data is being copied so is the tcontent data. I need to figure out how to sort that out now that you've highlighted the issue Thank you so much for your time. / comments
After all that I just realised tContent is NOT identical in both db's.I'm very sorry about that, I totally messed up that piece of information.I confused myself, it's NOT the same because at the sa...
Hi Jon, Thank you for taking the time out to reply and replicate. tContent is identical in both db's I followed the same screenshot as yours unfortunately the outcome is different Here is the data from source, target and the record identified from tcontent that needs to be copied to target. [image] In the filter i've added the following in tplugins and it's identified the correct one but also the other two which already exist in target. Sorry I've obscured some of the data but I have double/triple checked the ids and they are identical modId in (SELECT modId from tContent where site = 'du')[image] [image] As you can see here, 3 records have been identified to be inserted [image] And this is the scrip it creates, and when running this I get the following error Violation of PRIMARY KEY constraint 'PK_tplugins_id'. Cannot insert duplicate key in object 'dbo,tplugins'. The duplicate value is (24). Which is expected but this should be getting filtered out. [image] / comments
Hi Jon,Thank you for taking the time out to reply and replicate.tContent is identical in both db's I followed the same screenshot as yours unfortunately the outcome is differentHere is the data fro...