Ars Technica

SQL Schema and Data Compare (Red Gate Alternative)

I am looking for suggestions on an alternative product for comparing SQL schema and data with Microsoft SQL server (2012). Up to this point in time our company has used Red Gate SQL Compare and SQL ...
Ars Technica

Recommend a SQL Server table structure comparison & sync tool?

I have a need to compare multiple different versions of essentially the same SQL Server 2005+ databases and bring the table structures up to that which is in the newest version. It should compare the ...
dbta

Embarcadero Change Manager 5.1 Supports Schema Compare and Synchronization Between Sybase and SQL Server

Embarcadero Technologies has released a new version of its database change management software. Change Manager 5.1 helps DBAs and developers by automating complex database change management tasks, ...
InfoWorld

SQL Server 2005’s Schema Problem–An Elegant Solution

There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...
Visual Studio Magazine

Oracle/Java on Windows Azure and More Data Dev Tidbits

Data development news this week includes the availability of Oracle software and Java on Windows Azure, a service to quickly turn SQL Server stored procedures into RESTful APIs and a ...
dbta

Performance Comparison of SQL Server 2016 Columnstore Indexes with Memory-Optimized Tables

This whitepaper illustrates the SQL Server 2016 business intelligence/data warehouse upgrades, the memory-optimized tables, and the columnstore indexes. We also discuss the performance comparison of ...