Often at DB Best as part of our SQL Server 2005 upgrade efforts, a complex upgrade can sometimes take weeks to move into production. During that time, a DBA or application developer may make a change to the older production database without letting the upgrade team know. We like to call this schema or data drift. Originally created for database migration projects, we’ve created Database Compare Suite at DB Best to solve the problem of drift. Database Compare Suite for […]
Talks on Managing Data and Applications Anywhere
This continues our video blog series about new features, that are implemented in the new version of SQL Server Migration Assistant 7.0. And now we will talk about some important security issues. Row-Level Security (RLS) enables customers to control access to rows in a database table based on the characteristics of the user executing a query. The feature was introduced in SQL Server 2016. Starting from the 7.0 version the SSMA tool can handle Oracle VPD Policy and DB2 access controls, […]
The new version of SQL Server Migration Assistant (SSMA) 7.0 now supports direct migration to several new features introduced in SQL Server 2016. One of these new features is the direct support for migrating Oracle Flashback Archive tables to Temporal Tables. This is very important because earlier versions of SSMA attempted to partially migrate Flashback Archive tables to normal tables in SQL Server and left it up to the user to manually implement the behavior with a relatively high cost. […]
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 […]
Application and database upgrade or 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 project approach that we use for upgrade projects that is based on our proven Migration Methodology. This blog post provides you will an overview of the DB Best 12 Step Upgrade Project steps to help you prepare for your upgrade.
NOTE: Microsoft has since abandoned the SQL Server 2016 Upgrade Advisor and now calls the tool the Microsoft Data Migration Assistant (DMA). The concepts for using the tool are the same for using DMA as shown below. Please stay tuned for a new blog post that covers the capabilities of DMA. SQL Server 2016 has been released, and it is already making waves as a big step up from previous versions. Naturally, upgrading to SQL Server 2016 has an appeal that […]
SQL Server 2005 is now officially out of support. So, what are you waiting for? At DB Best Technologies, we’ve seen three key customer challenges that organizations have when running SQL Server 2005. In this blog post, we’ll introduce these challenges and provide examples of how DB Best can help you accelerate your upgrade path. Common customer challenges running with SQL Server 2005 and Windows Server 2003 Legacy systems require a higher level of maintenance When legacy systems encounter problems, […]
Microsoft has release an update to SSMA for Oracle, DB2, Sybase ASE, MySQL, and Access. SSMA simplifies the database migration process by automating all aspects of migration, including migration assessment analysis, schema, and SQL statement conversion, as well as migration testing to reduce cost and risk of your database migration project. This new version of SSMA provides the following enhancements: New command in the menu to view the SSMA log file. This provides an easy way to get to the […]
Our own Bill Ramos has completed a series of webinars on SQL Server 2016. They are now available for viewing on our Videos page. Topics include: What’s new with SQL Server 2016. This is a complete overview of all the new features in SQL Server 2016. Using SQL Server 2016 to accelerate your SQL Server 2005 workloads. This looks at the SQL Server 2016 feature set that would be useful for DBAs looking to upgrade from SQL Server 2005. What’s […]
We are excited to announce that Microsoft has selected us as one of the elite partners that they will feature on their SQL Server EOS website. We are honored to be recognized for our efforts in assisting other organizations upgrade Microsoft SQL Server so that they can use all of the exciting features that have been added over the past 11 years. We look forward to continuing these essential efforts into the next year and beyond!