I've been able to import tables successfully from Oracle
to a SQL Server database. However, when I try to import
views from Oracle it wants to import them as tables in
SQL Server. Any ideas how I can import views as views
from Oracle to SQL Server?

You'll need to import the data and then create the views on
SQL Server.

-Sue

On Mon, 23 Aug 2004 13:49:48 -0700, "Scott"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

I have moved some large databases from Oracle to sql. The best way to
move views from oracle to sql will be to script all the views in
oracle and then start editing the sql of all the views to make it work
on sql server and then run the script against the sql database.
This would be the easiest way. And yea if you have stored procedures
best of luck with that too.

"Scott" <anonymous (AT) discussions (DOT) microsoft.com> wrote