Hi,

I have a typed dataset that was once create from a database. As time
passed, we'd lost the original database, and had to recreate it.

However, we don't want manually to recreate the constraints also -
they are in the dataset.

Is there a way to automatically bring the constraints from the dataset
into the SQL database ?


Alex.

Well the primary key is an obvious.

All you really have to do is create the table with the same field names,
data types AND sizes (you can see this in the Adapter code VS generates.

"Alex" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed):
> Hi,
>
> I have a typed dataset that was once create from a database. As time
> passed, we'd lost the original database, and had to recreate it.
>
> However, we don't want manually to recreate the constraints also -
> they are in the dataset.
>
> Is there a way to automatically bring the constraints from the dataset
> into the SQL database ?
>
>
> Alex.

There is no need to create the tables. The database is there. I want
to bring the constraints from the dataset to the database.

Is there an alternative to doing a reflection-code on the dataset, and
issuing SQL statements that will create the costraints in the
database?

Is there a tool we can buy that can do it ?

Alex.

scorpion53061 <(E-Mail Removed)> wrote in message news:<#(E-Mail Removed)>...
> Well the primary key is an obvious.
>
> All you really have to do is create the table with the same field names,
> data types AND sizes (you can see this in the Adapter code VS generates.
>
> "Alex" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed):
> > Hi,
> >
> > I have a typed dataset that was once create from a database. As time
> > passed, we'd lost the original database, and had to recreate it.
> >
> > However, we don't want manually to recreate the constraints also -
> > they are in the dataset.
> >
> > Is there a way to automatically bring the constraints from the dataset
> > into the SQL database ?
> >
> >
> > Alex.