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

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
EricP37
0

Comments

2 comments

Sort by
  • Tianjiao_Li
    @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.
    Tianjiao_Li
    0
  • EricP37
    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.     
    EricP37
    0

Add comment

Please sign in to leave a comment.