Web Development

Ask something
Question Locked

Copy views from one SQL database to another

0 helpful
2 replies

by jeffrey.ho

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

2 replies

by tony hopkinson

Easiest way is simply to generate a script for them and then run it against a the target database I would have thought.

This discussion is closed to new replies.