How to create tables in an sql server databased based as a copy of table
structure from oracle..?

Could do i table by table but would prefer some kind of looping if possible.

However - it isn't an obscene amount of tables so I guess I can do it one by
one.....

About 140 of them....

The Wizard will probably do a basic job for you, but it will only do the
base tables at best, not any related constraints or such like. DTS is for
data transfer really not migration including objects, but no doubt there are
tools out there for this, it depends what you want it for.


--
Darren Green
http://www.sqldts.com

"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

The wizard is good for a starting point. You may need to change data types
of the columns after the wizard is done as some of the field datatype
mappings are not entirely the best options.

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Can I something about dbtimestamp....it seems as if i have bad records on
the oracle server - do i need an oracle procedure to change it to
string and then use this procedure from sql server ?


"Paritosh Pathak" <ppathak (AT) litton (DOT) c-bass.com> wrote

Not really, there is a certain format for datetime that Oracle uses and it
causes errors in dts.

I have used logic in the Oracle select statement to substitute the datetime
value with something relevant. For example if the we set the date to
'1/1/1900' if it is lower than the value in Oracle. You could use a case
statement in the Oracle select clause.

This may or may not work for you. I have found there is a disconnect
between datetime values (in DTS) as compared to Oracle.

-Paritosh


"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

But i'm having trouble selecting on the table from microsoft....in query
analyzer with linked server I tried to change the format
to string but it wouldn't let me...


"Paritosh Pathak" <ppathak (AT) litton (DOT) c-bass.com> skrev i en meddelelse
news:uQAZHcG6EHA.260 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

Can you post the sql you're having trouble with and the base structure of
the table it is running against?

"Kim Vardinghus-Nielsen" <johndoe (AT) test (DOT) com> wrote