V
Vayse
Hi
Still working away on my ADP. Originally I took a copy of the Live SQL
database, and made any changes to the copy. So I'm ready to update the Live.
Most of changes are new tables. So I've generated some scripts, from within
table design. Thank MS for the auto script generator, as I hate writing
scripts!
Some questions:
1) I now have several scripts. Is is better to create one large script and
paste them all in there?
2) In general, do people here prefer to run the scripts through code in
Access, or just run the scripts from within SQL Query Analyser?
3) The auto scripts don't take care of generating keys for Relationships. Is
there anyway this can be done automatically?
Thanks
Vayse
Still working away on my ADP. Originally I took a copy of the Live SQL
database, and made any changes to the copy. So I'm ready to update the Live.
Most of changes are new tables. So I've generated some scripts, from within
table design. Thank MS for the auto script generator, as I hate writing
scripts!
Some questions:
1) I now have several scripts. Is is better to create one large script and
paste them all in there?
2) In general, do people here prefer to run the scripts through code in
Access, or just run the scripts from within SQL Query Analyser?
3) The auto scripts don't take care of generating keys for Relationships. Is
there anyway this can be done automatically?
Thanks
Vayse