Re: how do I do dump and restore without bugging with constraint?

Net Tree Inc. wrote:
> Hi all,
>
> I am dumping both schema and data from old database to new one. The
> new database schema is somehow contain slightly different schema then
> the old one. When I do restore it shown alot errors related with
> constraints. How can I dump and to restore from old to new without
> dealing with constraint and just forces data dump to where it suppose
> to belong?
>
>
>
>


if you're dumping the schema and the data, you should be restoring into
an empty database, not into an existing database.