Mapping columns on table comparison

paulo_morgado

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?

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

paulo_morgado

Thanks. I was able to work around the issue using SQL Refactor.

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