Re: import constraints and indexes only

From: Dale Edgar <Dale_at_DataBee.com>
Date: Thu, 5 Dec 2002 07:39:07 +0000 (UTC)
Message-ID: <3def02cc.2087711@news.btclick.com>

Hi Tom

On Wed, 04 Dec 2002 09:35:47 GMT, "Tom" <tomNOSPAM_at_teameazyriders.com> wrote:

>I had a large import that timed out and left a few tables out which i have
>now added with a selective imp. How can i make sure all constraints and
>indexes are present also? Can i do an im= user/pass rows=n indexes=y
>constraints=y file=x ?

Grab the freeware DBATool - among other uses it can generate the DDL re-creation scripts for the constraints and indexes in a schema (or schemas). Just generate the scripts - then run them.

http://www.DataBee.com/dt_home.htm

Regards
Dale_at_DataBee.com Received on Thu Dec 05 2002 - 01:39:07 CST