SQL Scripts

[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

 

[Sylvain Lafontaine]

The best way is to use a comparaison tool such as RedGate SQL-Compare.
(There are many other on the market at varying prices).

You have to pay (I don't know if you can find one that will be free) but
these tools will be a real time saver.

 

[Vayse]

Btw, I downloaded a trail version of that RedGate software. Its excellent.
Thanks
Vayse