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

Is it possible to use Data Generator for a VIEW?

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

Best Answer

  • Options
    Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5

    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?


  • Options
    EricP37EricP37 Posts: 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.     
Sign In or Register to comment.