AWS Schema Conversion Tool: Offline mode
30 Aug 2016

This continues our video blog series on the AWS Schema Conversion Tool (SCT). We will demonstrate how the AWS Schema Conversion Tool allows users to work with saved projects in offline mode without a connection to the source and target databases. This feature significantly speeds up the work of migrating the database schema as part of the application modernization process. In offline mode, the AWS Schema Conversion Tool works with XML files that contain the metadata tree of all objects of the target and source databases, which were saved earlier in the project. In this video, we will demonstrate how to work with the saved project, describe th...

Tracking down discontinued SQL syntax with SQL Sniffer and Replayer
24 Aug 2016

Do you still have SQL Server 2000 database servers running in your organization? Do you have SQL Server 2008 R2 or older database servers running with databases using compatibility level of 80 for SQL Server 2000 compatibility? Running the SQL Server profiler over an extended period of time looking for deprecated and discontinued syntax may not be an option either. At DB Best, we have developed a solution called SQL Sniffer that works at the network switch level to solve this problem. By using the port mirroring feature at the network switch, SQL Sniffer looks for SQL statements coming from applications to specific SQL Server instances. SQL S...

Migrating an Oracle to MySQL Database using the AWS Schema Conversion Tool
23 Aug 2016

Welcome to the very first blog post on getting started with the AWS Schema Conversion Tool (SCT). This is the first video in a series of many where we’ll help familiarize our readers with the tool and see how it can be applied to real migration projects. In this video, we will demonstrate how to analyze an Oracle database’s readiness for migrating to an AWS Relational Database Service (RDS) MySQL database using an online project. The video walks through the process of connecting to an Oracle database, selecting MySQL as the target, creating an assessment report, reviewing the results, connecting the target MySQL database, and creating...

Portfolio spotlight: HIMYNAMEIS iOS application
09 Aug 2016

As dating apps rapidly become more ingrained in the culture of modern dating, some people cannot imagine life without them. However, every user knows how difficult it can be to portray yourself accurately with nothing but text and a few pictures. After all, seeing a static image does not suffice in fully understanding whether the person is The One, no one, or simply a great buddy. HIMYNAMEIS is a unique application that strives to make the online dating experience more genuine with an elegant solution to this problem: It allows users to create a short video presentation instead of a profile picture for introductions. Moreover, it makes dating...

12 sure steps to SQL Server upgrade success
12 sure steps to SQL Server upgrade success
02 Aug 2016

Upgrade and modernization projects for SQL Server should not be taken lightly. You might want to take advantage of the latest versions of SQL Server 2016. You might need to take your aging SQL Server 2000 or 2005 solutions running on older hardware and operating systems and get them onto a supported version of SQL Server. In either case, having a programmatic approach to upgrading your applications and databases is critical to keeping your business running. At DB Best Technologies, we have a 12-step approach for upgrade projects based on our proven Migration Methodology. These steps include thorough assessment, conversion of database schemas,...