Compares and synchronizes SQL database content.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
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.
- Posts: 1
- Joined: Wed Mar 06, 2013 10:29 am
Return to SQL Data Compare 10
Who is online
Users browsing this forum: No registered users and 0 guests