I’m having difficulties copying views from one SQL database to another. I tried the inport wizard but it copies the Views as tables in the destintation database. I don’t want them as tables, I need the Views to show up in the Views folder of the destination database.
Any suggestions?