SQL database comparison and synchronization
3.1K views | +0 today
Follow
SQL database comparison and synchronization
News and best known practices on SQL database comparison and synchronization.
Curated by Dona Konte
Your new post is loading...
Your new post is loading...
Scooped by Dona Konte
Scoop.it!

Compare SQL Server database schemas and synchronize database objects | ApexSQL Diff

Compare SQL Server database schemas and synchronize database objects | ApexSQL Diff | SQL database comparison and synchronization | Scoop.it
ApexSQL Diff can compare SQL Server database tables, views and all other SQL Server objects.
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

The DBA is Alive and Well—Here's Why - SQL Server Pro

The DBA is Alive and Well—Here's Why - SQL Server Pro | SQL database comparison and synchronization | Scoop.it
SQL Server Pro The DBA is Alive and Well—Here's Why SQL Server Pro Michael Otey, technical director for SQL Server Pro, says he laughs every time he hears statements like, "the DBA is dead" and is in complete agreement with Jones that the DBA is...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

Synchronization Errors (Cannot drop the index) - Microsoft Dynamics AX Forum - Microsoft Dynamics AX - Microsoft Dynamics Community

Microsoft Dynamics Community (Synchronization Errors (Cannot drop the index): It looks like a bug. After you run the DTA (Database Tuning Ad...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

ApexSQL Diff 2013 released

ApexSQL Diff 2013 released | SQL database comparison and synchronization | Scoop.it
Raleigh – October 17, 2013 – ApexSQL, a Microsoft Gold Certified Partner and major provider of Microsoft SQL Server solutions, today announced the release of ApexSQL Diff 2013.
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

ApexSQL Log 2013 vs Toad for SQL Server 6 performance advantages

ApexSQL Log 2013 vs Toad for SQL Server 6 performance advantages | SQL database comparison and synchronization | Scoop.it
Recently, we have made a series of performance tests on ApexSQL Log 2013.
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

SQL Server: Database integration and synchronization - DBA ...

SQL Server: Database integration and synchronization - DBA ... | SQL database comparison and synchronization | Scoop.it
I have n SQL Server databases with the same data schema. On the other hand i have a web application that needs to retrieve, for some entities, the union of the information stored into the n databases.
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

3 Tips for Rolling Your Own SQL Compare Tool with Database ...

3 Tips for Rolling Your Own SQL Compare Tool with Database ... | SQL database comparison and synchronization | Scoop.it
In most cases a database vendor's default SQL Comparison tool will do the job, but every once in a while I need a little more (e.g. a tool embedded as part of a continuous deployment process). Luckily I've found that it's not ...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

How Do I: Set Up and Monitor Database Synchronization in ...

This video demonstrates a series of steps on how to set up and monitor database synchronization in Microsoft Dynamics NAV 2013 R2. For more information on Microsoft Dynamics NAV 2013 R2, please visit our Getting ...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

Creating Simple Performance Baselines with SQL Server Profiler - SQL Server Pro (blog)

Creating Simple Performance Baselines with SQL Server Profiler - SQL Server Pro (blog) | SQL database comparison and synchronization | Scoop.it
Creating Simple Performance Baselines with SQL Server Profiler
SQL Server Pro (blog)
Baselines and subsequent comparison metrics make it easy to determine if index modifications or code changes are truly improving performance on heavily used servers.
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

ApexSQL Diff 2013 – Product update alert

ApexSQL Diff 2013 – Product update alert | SQL database comparison and synchronization | Scoop.it
ApexSQL Diff 2013 has been released Type: New version About ApexSQL Diff: ApexSQL Diff is a SQL Server and Windows Azure SQL database comparison and synchronization tool which detects differences between database objects and resolves them without...
Dona Konte's insight:

Finally free SQL database comparison tool for #SQL Server Express and Windows Azure Server #SQLserver

more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

compare tables in the same database without using mysqldump using mysql workbench: mysql

compare tables in the same database without using mysqldump using mysql workbench: mysql | SQL database comparison and synchronization | Scoop.it
Followup question to http://www.experts-exchange.com/Database/MySQL/Q_28239833.html I want to compare many tables without looking at a mysql dump file because it is difficult to compare inserts...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

What the Hell Is a SQL Injection, Anyway? - Gizmodo

What the Hell Is a SQL Injection, Anyway? - Gizmodo | SQL database comparison and synchronization | Scoop.it
What the Hell Is a SQL Injection, Anyway?
Gizmodo
It's essentially a way of injecting some code into a data-driven web server that allows the attacker to gain access to the entire contents of a database.
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

Passing the ACID Test Using NoSQL in the Enterprise - ProgrammableWeb (blog)

Passing the ACID Test Using NoSQL in the Enterprise - ProgrammableWeb (blog) | SQL database comparison and synchronization | Scoop.it
Passing the ACID Test Using NoSQL in the Enterprise
ProgrammableWeb (blog)
Most SQL database administrators (DBAs) worship at the altar of database reliability based on these attributes.
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

How to Survive on Free Tools for Month – SQL Data Compare ...

How to Survive on Free Tools for Month – SQL Data Compare ... | SQL database comparison and synchronization | Scoop.it
Note: This blog is based on ApexSQL Data Diff, download it and play along with is this blog post. In the previous article I wrote about comparing two Windows Azure SQL databases using free community version of ApexSQL ...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

BI SQL # 239 : SQL Server DBA Scripts : C. Compare Database

BI SQL # 239 : SQL Server DBA Scripts : C. Compare Database | SQL database comparison and synchronization | Scoop.it
Hi Folks, In this article we are going to cover 3 and last type of C. Compare Database. In this post we are going to discuss following points: Problem Statement of SQL Script: Description of SQL Sc...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

Microsoft releases SQL Server 2014 CTP2 - ZDNet

Microsoft releases SQL Server 2014 CTP2 - ZDNet | SQL database comparison and synchronization | Scoop.it
CruxialCIO Microsoft releases SQL Server 2014 CTP2 ZDNet At the opening keynote for this week's PASS Summit, Microsoft Corporate VP Quentin Clark announced the second Community Technology Preview (CTP) release of SQL Server 2014, the upcoming...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

Query to compare indexes between two tables - SQLServerCentral

Query to compare indexes between two tables - SQLServerCentral | SQL database comparison and synchronization | Scoop.it
And while there are lots of tools out there to compare all of the tables/indexes etc between two databases there aren't any that I've seen that will compare two tables in the same database. So to fill my need I've written a quick ...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

SQL Views: Steps to Setting Up SQL Agent - SQL Server Pro

SQL Views: Steps to Setting Up SQL Agent - SQL Server Pro | SQL database comparison and synchronization | Scoop.it
SQL Views: Steps to Setting Up SQL Agent
SQL Server Pro
SQL Server Agent enables you to automate operations by running jobs on one or more systems according to a predetermined schedule or predefined alerts.
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

ApexSQL Diff 2013 Released - Virtual-Strategy Magazine (press release)

ApexSQL Diff 2013 Released - Virtual-Strategy Magazine (press release) | SQL database comparison and synchronization | Scoop.it
ApexSQL Diff 2013 Released Virtual-Strategy Magazine (press release) About ApexSQL Diff: ApexSQL Diff is a SQL Server and Windows Azure SQL database comparison and synchronization tool which detects differences between database objects and resolves...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

Cloud Platform Blog: Google Cloud SQL is now accessible from just ...

Cloud Platform Blog: Google Cloud SQL is now accessible from just ... | SQL database comparison and synchronization | Scoop.it
MySQL Wire Protocol is the standard connection protocol for MySQL databases. It lets you access your replicated, managed, Cloud SQL database from just about any application, running anywhere. Here are some of the top ...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

Hacker group claims to have looted $100k via SQL injection attack - SC Magazine

Hacker group claims to have looted $100k via SQL injection attack - SC Magazine | SQL database comparison and synchronization | Scoop.it
Hacker group claims to have looted $100k via SQL injection attack SC Magazine A successful SQL injection exploit can read sensitive data from a database, modify that data, execute administration operations on a database or, in some cases, issue...
more...
No comment yet.
Suggested by Richard Boss
Scoop.it!

XML Configuration in SQL | TechNet

XML Configuration in SQL | TechNet | SQL database comparison and synchronization | Scoop.it
SQLXML enables XML support for SQL Server, bridging the gap between XML and relational data. Lets see in this tutorial the basics of configuring XML in SQL Server and retrieving the data in XML format.
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

How to Hack Databases: Hunting for Microsoft's SQL Server - Null Byte

How to Hack Databases: Hunting for Microsoft's SQL Server - Null Byte | SQL database comparison and synchronization | Scoop.it
Welcome back, my fledgling hackers! The database is the hacker's "pot-of-gold," as it contains information that is very valuable to both the business and the hacker. In this, the second of my series on hacking databases, we're ...
Dona Konte's insight:

Learn and protect your databases

more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

Idera Announces SQL Diagnostic Manager 8.0 With Management Pack for ... - Marketwired (press release)

Idera Announces SQL Diagnostic Manager 8.0 With Management Pack for ... - Marketwired (press release) | SQL database comparison and synchronization | Scoop.it
Idera Announces SQL Diagnostic Manager 8.0 With Management Pack for ...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

CA Takes Cue From Open Source: Free Monitoring Tool - InformationWeek

CA Takes Cue From Open Source: Free Monitoring Tool - InformationWeek | SQL database comparison and synchronization | Scoop.it
CA Takes Cue From Open Source: Free Monitoring Tool InformationWeek The Snap version includes 20 probes and can discover and monitor the operation of Microsoft Exchange, Microsoft's IIS Web server, Microsoft SQL Server and open source MySQL...
more...
No comment yet.
Scooped by Dona Konte
Scoop.it!

Using An ALL Operator To Compare Count(*) Values - (SQL ...

Using An ALL Operator To Compare Count(*) Values - (SQL ... | SQL database comparison and synchronization | Scoop.it
Using an ALL operator to compare count(*) values - (SQL). Posted Yesterday, 01:56 AM. Hi everyone! This is frustrating me like crazy. I want to compare a count(*) to all other counts, and display the highest value that it finds.
more...
No comment yet.