White Papers
The DB Best SQL Sniffer is a network protocol analyzer for DBMSys application. It lets you capture, log and interactively browse database queries from SQL, Oracle and Sybase servers. SQL Sniffer also supports saving captured packets to a file for further analysis and allows to find out installed server versions. SQL Sniffer enables your organization to dramatically reduce risk and time needed to perform database upgrades with the ability to replay queries against the newer version of the database.
If your organization is heavily invested in a legacy Oracle database environment, you may be confronted with rising license renewal and support/maintenance costs for outdated technologies. To keep pace with rapidly changing business demands, consider working with DB Best to migrate to Amazon Aurora for increased business flexibility and cost-effectiveness. We offer expertise for customers migrating to Amazon Aurora based on best practices they have developed through years of customer engagements.
This whitepaper describes an automatic solution to deploying SQL Server Integration Services packages and projects with Visual Studio Team Foundation Server using PowerShell and T-SQL scripts. The technique described in this paper provides a great framework for organizations practicing DevOps and development teams looking for a way to manage development and deployment of SSIS in a development/test/production environment. The paper bases the architecture of the solution on Build and Release in VSTS and TFS capabilities within Visual Studio Team Foundation […]
Summary: This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2014. Instructions for handling the differences between the two platforms are included. The paper describes how SQL Server Migration Assistant, the best tool for this type of migration, can help resolve various migration issues. Writers: Yuri Rusakov (DB Best Technologies), Alexander Pavlov (DB Best Technologies), Nataliia Lakoshko (DB Best Technologies), Igor Yefimov (DB Best Technologies) Technical Reviewer: Dmitry Balin (DB Best Technologies) Published: […]
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2014. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration process using SQL Server Migration Assistant (SSMA) v6.0 for Oracle is explained in depth, with a special focus on converting database objects and PL/SQL code. This paper was written by Yuri Rusakov, Igor Yefimov, Anna Vynograd and Galina Shevchenko from […]
Robert Davis (aka @SQLSoldier) provides clear guidance on the differences between Merge and Peer-to-Peer replication and how to decide which method is the right one to use for your particular scenario. Merge replication has been part of SQL Server since version SQL Server 7.0, released in 1998. Peer-to-Peer replication (P2P) is a newer topology first available in SQL Server 2008. Peer-to-Peer was positioned as the preferred replacement for transactional replication with updatable subscribers which was deprecated in SQL Server 2008. Many […]