Invoke-Sqlcmd variable parameter
Using PowerShell Invoke-Sqlcmd with Variable parameter
26 Feb 2020

I recently needed to use PowerShell to call a T-SQL script using Invoke-Sqlcmd with the -Variable parameter. In my case, I wanted to specify the locations for backup files and where to restore the data and log files. Rather than add the conditions into the SQL script, I wanted to make the SQL script as generic as possible, and use SQLCMD variables for the different scenarios. In this blog, I’ll show how to use the array sub-expression operator and “splatting” with hash tables to build the parameters needed for the Invoke-Sqlcmd cmdlet. Isn’t using Powershell Invoke-Sqlcmd with the -Variable parameter straightforward? W...

Migration Platform update
Improving the Test Organizer module of the DB Best Migration Platform
20 Feb 2020

DB Best released a new version of Migration Platform, our ultimate product for automating database migrations. In this release we added new features to the Test Organizer module, a unique and unrivaled feature of the DB Best Migration Platform. We also made several improvements of the user interface. In this blog post, we will cover these new application features, however, we recommend you starting with our previous blog posts: A typical workflow of the DB Best Migration Platform Using the Test Organizer What’s new in the DB Best Migration Platform 1.1? First of all, users can create universal tests and run them against different databa...

CI/CD best practices
Applying CI/CD for deploying data-driven applications after migrating from Oracle to Amazon Aurora PostgreSQL
14 Feb 2020

When it comes to database migrations, application conversion/remediation along with functional testing of the entire system account for over 50% of the total effort. By using a proven CI/CD process, we’ve been able to reduce the overall migration time and create repeatable processes for on-going changes after the migration. In this blog post, we’ll talk about how we helped a large multinational software company with ambitious growth plans migrate their Oracle Database and Java solution to Amazon Aurora PostgreSQL. What used to take 54 hours to deploy new releases before, only takes 4.5 hours with their new CI/CD process! Technolog...

DevOps process Oracle Forms
Automating Oracle Forms and Reports conversion with a DevOps process
06 Feb 2020

The DB Best Oracle Forms and Reports Converter automates the conversion of your forms to a modern Web 2.0 architecture. We use the Oracle provided FormModules, ObjectLibraries, or MenuModules to XML command-line tool called Forms2XML along with the corresponding Oracle Reports convert to XML tools to start the process. Our converter then processes the source XML files to JavaScript files and SQL code fragments. In this blog post, we will show our best practices for incorporating our Oracle Forms and Reports Converter into a Continous Integration (CI) / Continous Deployment (CD)  DevOps process to shorten developer lead time and reduce chan...

Database Compare Suite command-line interface
Automating data management operations with CLI scripts in Database Compare Suite
03 Feb 2020

We continue our blog post series covering key Database Compare Suite (DBCS) features. In our previous posts, we talked about comparing data and discovering data differences by leveraging the user interface of Database Compare Suite. The command-line interface of our product provides users with all the features of the main application. In this blog post we will talk about using Database Compare Suite for data management tasks in the CLI mode. Why use Database Compare Suite in the CLI mode? This approach allows for increased productivity. Simply put, you prepare the script once and then use it every day. Also, finding the objects you need to c...