What are the challenges you face when working across database platforms? Take the survey
Options

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.
Tagged:

Best Answer

  • Options
    David AtkinsonDavid Atkinson Posts: 1,451 Rose Gold 2
    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

Answers

  • Options
    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
  • 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.
  • Options
    sarathbabu_sbsarathbabu_sb Posts: 3 New member
    Hi David,

    Thank you its working for me.
Sign In or Register to comment.