ASP.NET, SQL Server, WPF, C#, VB.NET

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. 
 
-- 
 
Sylvain Lafontaine, ing. 
 
MVP - Technologies Virtual-PC 
 
E-mail: http://cerbermail.com/?QugbLEWINF 
 
"Vayse" <vayse@deadspam.com> wrote in message 
 
news:%23DotevUvGHA.4756@TK2MSFTNGP02.phx.gbl...

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