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.

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

Some of the best open source SQL Clients for Database Management are Sqlectron, SQuirrel SQL client, SQL Chat, OmniDB, HeidiSQL,Falcon, etc.

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

AquaFold, Inc. has released Aqua Data Studio 18, a major upgrade to its universal database management and analytics software, providing schema synchro ...

Idera, a provider of management and administration solutions for Microsoft SQL Server, has announced SQL comparison toolset v1.1, a solution that is aimed at helping DBAs save time in comparing and ...

Promising that developers can 'save weeks of development effort,' Microsoft today answered their request for database project support in Visual Studio to target Azure SQL Data Warehouse projects.

Quest Software recently made a joint announcement with Microsoft, indicating that it will offer an Oracle Database Schema Provider for the upcoming release of Microsoft Visual Studio Team System (VSTS ...

To do this, we’ll use an SQL Server Agent Job. Using SQL Management Studio, create a new SQL Server Agent Job: Fill in the general details and then go to the Steps page to add a couple of steps.