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

Not seeing View details

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.
Sarathbabu_sb
0

Comments

4 comments

Sort by
  • 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.
    David Atkinson
    0
  • 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
    0
  • 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
    0
  • sarathbabu_sb
    Hi David,

    Thank you its working for me.
    sarathbabu_sb
    0

Add comment

Please sign in to leave a comment.