I have a template DB. Very often, I have to create databases with this template and add views. There is 4 types of view and I have to create usually 20 of each just by changing their name, alias, one column name and one columns sort style. I want to automate this or I will be crazy soon.
Do you know a way to do it in VB.Net using Com objects? Do you know another way to do it easier?