Not seeing View details

sarathbabu_sb · June 29, 2018 12:39PM

Hi,

I have modified one of the view in my development system. I wanted to transport this view to my test environment. I am using SQL data compare to do this activity. But when I went to Tables & views tab, I am able to see only table not views. Please help any one to resolve my problem.
Thanks,
Sarath.

David Atkinson · June 29, 2018 12:59PM

Once you've compared your source and target, run the comparison, you'll get to the comparison results screen. Here you will see the changed view. Simply click on Deploy and follow the wizard.

David Atkinson · June 29, 2018 12:43PM

To move the view object definition itself you need to use SQL Compare, not SQL Data Compare. If you want to move the data itself, you can use SQL Data Compare. By default this is not shown in "Tables and Views", so you need to go to "Options", Mapping Behavior, Include views.

sarathbabu_sb · June 29, 2018 12:53PM

Hi David,
Thank you for your replay.

I am not getting option in sql comparison tool to transport view. could you please guide me how to to do that.

Thanks in advance.

sarathbabu_sb · June 30, 2018 6:25PM

Hi David,

Thank you its working for me.

Not seeing View details

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk