Red Gate forums :: View topic - Options of Sync Schema
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

Options of Sync Schema

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
u504245349



Joined: 11 Apr 2012
Posts: 3

PostPosted: Mon Nov 25, 2013 10:01 am    Post subject: Options of Sync Schema Reply with quote

I use SQL Comparison SDK 10
I try to sync database's schema [A] to database's schema [B].
Ex.
-- Before Sync
[A] have 1 table 3 columns - [B] 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 - [B] 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 - [B] 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 [B] only ,
I don't to drop something from [B].

How do I do ??

Regard,
Sek
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6645

PostPosted: Tue Nov 26, 2013 4:23 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group