William
Mon Apr 26 09:07:07 CDT 2004
AFAIK, yes, if it will do it for you automatically, I've never gotten it to
work and I've tried a few times. It may be possible, but I really don't
think so.
"aguyngueran" <aguyngueran@tlen.pl> wrote in message
news:uN7SqK4KEHA.1312@TK2MSFTNGP12.phx.gbl...
>
> "William Ryan eMVP" <bill@NoSp4m.devbuzz.com> wrote in message
> news:eLsF9RyKEHA.3944@tk2msftngp13.phx.gbl...
> >
> > "aguyngueran" <aguyngueran@tlen.pl> wrote in message
> > news:ermYV$wKEHA.2660@TK2MSFTNGP09.phx.gbl...
> > > Hello there,
> > >
> > > How can I automatically create strongly typed data set from existing
SQL
> > > Server 2000 tables.
> > > I know that I can drag and drop a table to generate one, but I'd like
to
> > > generate strongly typed
> > > data set for all specified tables with relations between them ?
> > Yes
> > > possible with Microsoft Visual
> > > Studio Enterprise Architect 2003 or another tool ?
> >
> > This will work. You can just open up server explorer and drag the other
> > tables into the dataset. You'll get another adapter, choose Generate
> > Dataset and then choose existing dataset (the one from the first table)
> and
> > that'll put them in there. You still need to generate the relationships
(I
> > think - pretty sure about this) but the keys will come in and that's the
> > tough part. So basically just drag out each table, and when you
generate
> > dataset, just make sure you add them all to the same one.
> >
>
> But do I have to generate relationships manually ? I'd like to map about
140
> tables
> and it'd be very difficult to create it by hand
>
>
> Best regards
> Rafa³ Grzybowski
>
>