Mapping columns on table comparison

paulo_morgado · June 8, 2010 9:04PM

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 · June 10, 2010 2:50PM

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 · June 10, 2010 8:22PM

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

David Atkinson · October 17, 2011 5:34PM

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

Mapping columns on table comparison

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk