Red Gate forums :: View topic - How to sync different-sized data with part of it inserted?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

How to sync different-sized data with part of it inserted?

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
winstein



Joined: 06 Mar 2013
Posts: 1

PostPosted: Thu Mar 07, 2013 3:02 am    Post subject: How to sync different-sized data with part of it inserted? Reply with quote

To Redgate,

Currently, I am facing a problem of not being able to synchronise any data if their fields have a different capacity. If I have a field with nvarchar(24) as a Source and nvarchar(14) as a Target, then I could synchronise any data with 14 characters or less. However, if I were to have data with 15+ characters, then the whole process will be cancelled.

Is there any way to synchronise it so that part of the data field will be shown (so, something like "12334567890123456" becomes "12345678901234"). If that's not possible, is it possible to at least have part of the data where it's eligible, without resorting to selecting the individual fields in the compare section?

Thanks for reading.
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