call us toll-free +1 855 855 3600
 
Home > Whitepapers
 

White Papers

 
 

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 […]

 

Read more

 
 
 
 

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 […]

 

Read more

 
 
 
 

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 […]

 

Read more

 
 
 
 

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, […]

 

Read more

 
 
 
 

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 […]

 

Read more