Competition: What’s your favorite Redgate tool? Enter now.

Is it possible to use Data Generator for a VIEW?

EricP37EricP37 AtlantaPosts: 6 Bronze 1
in SQL Data Generator
I am testing some partitioned views and wanted to use data generator to generate data for my testing. 

Is it possible to use Data generator for a view?

Thanks in Advance
Tagged:
· Share on Twitter

Best Answer

  • Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    Accepted Answer
    @EricP37

    I'm afraid it's not possible to populate a view directly. However, you can obviously generate data into the tables that support the view which hopefully be sufficient for you.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter

Answers

  • EricP37EricP37 AtlantaPosts: 6 Bronze 1
    edited March 20, 2019 5:50PM
    It is possible to update or insert data into a view.   It is the tool that does not allow a view to be pulled up for data population.  

    To REDGATE, this should be an easy enhancement to the tool.    Pull the list of views from the sys.objects DMV and change the type from 'U' (user table) to type in 'U' and 'V' .  The sys.columns DMV would still be able to pull the columns in either a user table or view.     
    · Share on Twitter
Sign In or Register to comment.