What are the challenges you face when working across database platforms? Take the survey
Options

Options of Sync Schema

u504245349u504245349 Posts: 5
I use SQL Comparison SDK 10
I try to sync database's schema [A] to database's schema .
Ex.
-- Before Sync
[A] have 1 table 3 columns - have 1 table 4 columns
ItemCode NVarChar(50) | ItemCode NVarChar(50)
Itemname NVarChar(50) | ItemName NVcarChar(30)
UnitPrice Float | ...............
...... | UnitName NVarChar(50)
...... | Remark Text


-- After Sync (Real)
[A] have 1 table 3 columns - have 1 table 3 columns
ItemCode NVarChar(50) | ItemCode NVarChar(50)
Itemname NVarChar(50) | ItemName NVcarChar(50) << edit
UnitPrice Float | UnitPrice Float
...... | ................. << drop
...... | ................. << drop

-- After Sync (My needs)
[A] have 1 table 3 columns - have 1 table 5 columns
ItemCode NVarChar(50) | ItemCode NVarChar(50)
Itemname NVarChar(50) | ItemName NVcarChar(50) << edit
UnitPrice Float | UnitPrice Float
...... | UnitName NVarChar(50) << add new
...... | Remark Text << add new

I need to edit and add new columns on only ,
I don't to drop something from .

How do I do ??

Regard,
Sek

Comments

  • Options
    Hi Sek,

    This does not seem to be possible. The SQL Compare user interface lets you map different columns to preserve data, but you can only map one column to another. I thought you could try removing the SqlCompareFieldmappings from the table so the additional columns would be ignored, but the SDK does not even let you access the SqlCompareFieldmappings.

    Best I can think of doing is save the script and manually adjust it to remove the column drops. I don't have an example for that, though.
Sign In or Register to comment.