Only Source to Target Comparision

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
flores1980
Posts: 3
Joined: Wed 21 May 2014 07:35

Only Source to Target Comparision

Post by flores1980 » Wed 21 May 2014 07:54

Im making a comparision between two DBs and dbForge Schema Compare is joining tables instead of changing source diferent things into target.
I dont want to delete columns in target not in Source. I only want to add columns that are in source but not in target.

In the snapshot example, dbForge syncronization is going to add the "NumCuenta" from source to target (This OK) column but also is going to delete columns "ConceptoRecibo", "Rectificada" and "IdRectificacion" from target because they are olnly in target (NOT OK for me)

Is there any configuration option to get this behavior?

Image
imagen jpg

Thanks.

alexa

Re: Only Source to Target Comparision

Post by alexa » Wed 21 May 2014 09:51

In the resulting synchronization script, you would need to manually remove the columns specified for deletion.

Post Reply