How can we help you today? How can we help you today?

Custom Key

So far loving the new vs5, can anyone point me to documenation for using custom keys in data compare? Before I ask questions I'd like to read what and how custom keys are meant to work to compare tables without keys. Are they just for the compare or a Permanent change to the file, best ways to use, tips, gotchas etc. May be I'm just brain dead at the moment, just want to refresh or readup on the topic.
Thanks
Steve
Steve C
0

Comments

2 comments

Sort by
  • James Moore
    Steve,

    I went through most of the new features in Data Compare in my blog: http://blogs.red-gate.com/blogs/james/archive/2006/02/27/Data_Compare_5_Beta.aspx


    Just a little information on Custom Comparison keys that you and perhaps others will find useful. In previous versions of Data Compare you needed to have an index/pk on a table to compare them, or a clustered index on a view.

    The idea behind custom comparison keys is that you can now compare tables and views with no pk/index defined by telling data compare explicitly which column pair(s) to use when matching up records in the two databases you are comparing.

    Custom Comparison keys do not alter your database but you should be careful which columns you pick (and in general they should be unique) as it will effect the comparison and the eventual sync script Data Compare generates.

    If its still not clear then let me know or best of all give them a try...

    - James
    --
    James Moore
    Software Engineer
    Red Gate Software Ltd
    James Moore
    0
  • Steve C
    Thanks
    I thought that was the case but like to see it before plunging ahead with misconception. Will read the blog and play.

    Steve
    Steve C
    0

Add comment

Please sign in to leave a comment.