Re: Oracle to sql

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 12:58:06 -0000

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@hotmail.com> wrote in message
news:ezT1m4Q4EHA.3708@TK2MSFTNGP14.phx.gbl...
> 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....
>
>
>
>