Options

Not seeing View details

sarathbabu_sbsarathbabu_sb Posts: 3 New member
in SQL Compare
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.
Tagged:
· Share on Twitter

Best Answer

  • Options
    David AtkinsonDavid Atkinson Posts: 1,439 Rose Gold 2
    Answer ✓
    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
    Product Manager
    Redgate Software
    · Share on Twitter

Answers

  • Options
    David AtkinsonDavid Atkinson Posts: 1,439 Rose Gold 2
    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
    Product Manager
    Redgate Software
    · Share on Twitter
  • Options
    sarathbabu_sbsarathbabu_sb Posts: 3 New member
    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.
    · Share on Twitter
  • Options
    sarathbabu_sbsarathbabu_sb Posts: 3 New member
    Hi David,

    Thank you its working for me.
    · Share on Twitter
Sign In or Register to comment.