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

Mapping columns on table comparison

Is there a way to map columns in table comparisons?

Let's say that in database A I have column Stuff int in table T and in database B I have column BigStuff bigint.

I want o generate a script that T.Stuff int into T.BigStuff bigint and preserve data.

Is this possible?
paulo_morgado
0

Comments

3 comments

Sort by
  • peter.peart
    Hi Paulo,

    This isn't possible using SQL Compare although there is an existing feature request in place to allow column level mappings and more granular control over objects as a whole which will be reviewed for version 9 of the tool due out later this year.

    In the meantime, you may wish to have a look at SQL Refactor as this includes a feature called "Smart Rename", which allows you to rename an object / column and take care of all the relevant dependencies of that object / column accordingly as well as preserve data that you have in there.

    HTH!

    Pete
    peter.peart
    0
  • paulo_morgado
    Thanks. I was able to work around the issue using SQL Refactor.
    paulo_morgado
    0
  • David Atkinson
    Table mapping is now possible in SQL Compare 9.5

    http://www.red-gate.com/MessageBoard/vi ... hp?t=14113

    Let us know if this is what you expected.

    David Atkinson
    Red Gate Software
    David Atkinson
    0

Add comment

Please sign in to leave a comment.