>This may already be possible. But if not just as you can copy a table from one database to another, it would be nice to copy a view from one table to another.

I guess you're aware that you can do this pretty easily with EView.