Not seeing View details

sarathbabu_sb

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

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

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

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

Hi David,

Thank you its working for me.