Oracle to SQL Server

I've got a commercial Oracle database that I need to reverse engineer
to SQL server.
Using ER/Studio, I've generated the DDL for the tables, but one of the
lines references setting an image datatypes default to Empty_Blob, not
Null, and Query Analyzer gives me an error when it tries to interpret
that portion "Empty_Blob" of the DDL.
Any ideas how I should handle this?
CREATE TABLE abcdefg (
CRL image DEFAULT EMPTY_BLOB() NOT
NULL,
LAST_DOWNLOAD datetime NULL,
NEXT_DOWNLOAD datetime NULL,
SOURCE_URL varchar(1000) NULL,
THUMBPRINT varchar(60) NOT NULL
)
GO
--
HTH
Dale FyeI have no idea what EMPTY_BLOB is (maybe a user defined type?) but how about
'' instead.
--
Andrew J. Kelly
SQL Server MVP
"Dale Fye" <dale.fye@.nospam.com> wrote in message
news:OWcP3%23xnDHA.2244@.TK2MSFTNGP12.phx.gbl...
> I've got a commercial Oracle database that I need to reverse engineer
> to SQL server.
> Using ER/Studio, I've generated the DDL for the tables, but one of the
> lines references setting an image datatypes default to Empty_Blob, not
> Null, and Query Analyzer gives me an error when it tries to interpret
> that portion "Empty_Blob" of the DDL.
> Any ideas how I should handle this?
> CREATE TABLE abcdefg (
> CRL image DEFAULT EMPTY_BLOB() NOT
> NULL,
> LAST_DOWNLOAD datetime NULL,
> NEXT_DOWNLOAD datetime NULL,
> SOURCE_URL varchar(1000) NULL,
> THUMBPRINT varchar(60) NOT NULL
> )
> GO
> --
> HTH
> Dale Fye
>
>|||Dale,
There is no concept of EMPTY_BLOB in SQL Server. You can default the same to
NULL or as '' when using the same ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Dale Fye" <dale.fye@.nospam.com> wrote in message
news:OWcP3%23xnDHA.2244@.TK2MSFTNGP12.phx.gbl...
> I've got a commercial Oracle database that I need to reverse engineer
> to SQL server.
> Using ER/Studio, I've generated the DDL for the tables, but one of the
> lines references setting an image datatypes default to Empty_Blob, not
> Null, and Query Analyzer gives me an error when it tries to interpret
> that portion "Empty_Blob" of the DDL.
> Any ideas how I should handle this?
> CREATE TABLE abcdefg (
> CRL image DEFAULT EMPTY_BLOB() NOT
> NULL,
> LAST_DOWNLOAD datetime NULL,
> NEXT_DOWNLOAD datetime NULL,
> SOURCE_URL varchar(1000) NULL,
> THUMBPRINT varchar(60) NOT NULL
> )
> GO
> --
> HTH
> Dale Fye
>
>