There is a new program out (currently in beta testing) that will convert
Oracle to SQL, SQL to Oracle, SQL to Access, Access to SQL, ....
Basically, it can convert any ODBC OLE db to any other one. It will also
guide you through any conversions that are necessary. (i.e., sql doesn't
support the memo field).
It is called Schemer Advanced. It can be downloaded at:
If you have an exiting Access or oracle db. Create a customer connnection
or use an existing ODBC System DSN that you already have on your machine.
Schemer will show you the tables of that database. Simply right click on
the table that you want to copy, select copy, then click on the database
that you want to paste the table in and click paste. That's it. it will
convert it for you.
I have used Schemer and thoroughly enjoy it. We use Schemer at work
primarily because it is so flexible. We deal with Access, SQL 7.0, and
some Oracle. Schemer lets us manipulate all three db's in one program.
Part of my job is to run some queries from the different databases and
produce some reports. What used to take me about 3 hrs (queries copied to
excel then turned into a report) before, I can now do in less than 15
minutes. I just tell Schemer to export my results as an HTML pages.
We are still in the free 30 day trial period for the program (which is
nice), but like it so far.
> Can anybody help with this problem? I have a table that is on Oracle
> and I am using the Linked Server process to get to it. I do not want
> to copy the data to my server only link to it. However when I try to
> create a view so that I can easily gain access to it I get the message
> Server: Msg 7354, Level 16, State 1, Procedure cvobligr, Line 2
> OLE DB provider 'MSDAORA' supplied invalid metadata for
> column 'OR_NT_BOOK_BL_AM'. The data type is not supported.
> Here is some sample SQL of what the create statement is like:
> Create View test as
> Select * from oracle..cool.testtable
> Do I need to spell out the data conversion with the CONVERT statement.
> The field in question is a Number field. If you are familiar with
> ErWin when I look at the datamodel for the oracle database and convert
> the table in question to a model for SQL Server 7 it converts the
> Number format of the field to a float. It is generally a large
> I really need this information to be accessible in my SQL Server app.
> Also, I have no problem with linking this database into MS Access 97
> through ODBC.
> Any help would be greatly appreciated. I am beating my head on the
> wall with this one.
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Posted via CNET Help.com