I've been using the Schema and Data Compare tools built into Visual Studio. They seem to work pretty nicely and will generate change scripts. Might be worth a look if you've already got Visual Studio.

From a T-SQL perspective, the SchemaOnly option forces the SQLDataReader to precede the command with a SET FMTONLY ON statement. Listing 1 shows the Visual Basic ADO.NET source code to obtain a data ...

Working with SQL Server Data Tools. Lenni Lobel, chief technology officer of Sleek Technologies and author of Programming Microsoft SQL Server 2012 (Microsoft Press), offered a walk through of the SQL ...