sql server odbc: Importing views from Oracle -- sql server odbc

Importing views from Oracle

Scott
8/23/2004 1:49:01 PM

sql server odbc:

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

Re: Importing views from Oracle

Sue Hoegemeier
8/24/2004 6:40:44 AM

A view is a virtual table. Technically, to import just the
view you would only be importing the view definition, not
the data. Import the data and then create a view in SQL
Server.

-Sue

On Mon, 23 Aug 2004 13:49:01 -0700, "Scott"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.