Product articles SQL Compare Database Builds and Deployments
Using SQL Compare with In-Memory OLTP…

1 August 2016
1 August 2016

Using SQL Compare with In-Memory OLTP tables

SQL Compare can help you compare two databases that have In-Memory objects, the tables, their indexes and any natively-compiled procedures, and generate the appropriate scripts.

If you’ve read my simple assessment of SQL Server’s In-Memory OLTP tables on Simple-Talk and have decided to implement them, we’re in a position to support your move. Redgate SQL Compare can help you compare two databases that have In-Memory objects, the tables, their indexes and any natively compiled procedures, and generate the appropriate scripts.

In the SQL Compare project below, for example, I’m comparing the new WideWorldImporters sample database that has In-Memory tables, and a test database on my server:

SQL-Compare-In-Memory-1

If I run a compare between these databases, a number of differences come up. You can select the specific objects, in this case tables, that you want to migrate. Selecting one of the tables for migration, you can see that the script shows the table will be created using In-Memory commands:

SQL-Compare-In-Memory-2

You can then deploy these objects using SQL Compare and everything will work fine, assuming you’ve set up the second database to support In-Memory tables. However, if you’ve not done this, we will stop the deployment:

SQL-Compare-In-Memory-3

This is to ensure your scripts will run successfully to deploy the In-Memory objects in question. You’ll also note we deal with how transactions have to work with In-Memory tables. Not only do we support the In-Memory functionality – we continue to offer guidance and assistance in your implementation of the new functionality.

To see SQL Compare in action, comparing and deploying In-Memory tables, take a look at this short walkthrough video

Conclusion

In short, when you’re ready for In-Memory OLTP behaviors, SQL Compare wil be there to help. We support the objects and data types and we have checks in place to help ensure your success when moving In-Memory objects between databases using SQL Compare.

Try it now free or ‘Check for Updates’ under the Help menu in-product to make sure you’re on the latest version.

Tools in this post

SQL Compare

Compare and synchronize SQL Server database schemas

Find out more

You may also like

  • Article

    SQL Source Control v7 Enhancements

    Stephanie Herr summarizes what's new in SQL Source Control v7, including support for Git hooks, Git repositories hosted on Azure DevOps, and pre- and post-deployment scripts.

  • Webinar

    Accelerate innovation with Compliant Database DevOps

    With the increasing threat of data breaches tech companies are being forced to adopt new ways of ensuring they can increase the speed of delivery while also remaining compliant. In this webinar, we discuss how Compliant Database DevOps will help you balance the need to deliver software faster and cheaper, with the need to protect and preserve business critical data – allowing you to innovate at speed.

  • Event

    Microsoft Future Decoded

    Microsoft Future Decoded is your essential guide to disruptive technology and how it will impact people and businesses, today and tomorrow. Back for a fourth year, Microsoft Future Decoded will focus on current and emerging trends at the cross over of business and technology. With cloud, big data and artificial intelligence already rewriting the rules

  • Article

    Introducing database automation with the SQL Toolbelt

    For many companies, particularly those in the financial sector, a key technology consideration is risk management because if systems go down, it can cost a lot of money very quickly. Take ABSA Bank, a subsidiary of the Barclays Africa Group. Serving customers in South Africa and Namibia, it provides retail, business, corporate, and investment banking,

  • Forums

    SQL Compare Forum

    Compares and synchronizes SQL Server database schemas