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

  • Webinar

    Extending DevOps to the database: branching and merging

    Join our webinar to learn how Redgate’s Database DevOps solution works to improve your database development and deployment processes. With a focus on branching and merging, we’ll show how Redgate tools plug into Visual Studio Team Services (VSTS) to enable the build, test and deployment of your database changes.

  • Article

    Insert Statement Without Column List (BP004)

    Many production databases have failed embarrassingly as a result of INSERT code that omits a column list, usually in mysterious ways and often without generating errors. Phil Factor demonstrates the problem, and advocates a 'defense-in-depth' approach to writing SQL, in order to avoid it.

  • Article

    A DBA's Journey towards Database DevOps

    John Morehouse describes how a quest to help solve his organization's "deployment bottleneck" led them to a place where they could both deliver application and database changes into the wild at a pace to satisfy customer demand, and achieve a better work-life balance for the team, both of which are well worth having.

  • Article

    Q&A from our recent ‘What’s New in SQL Toolbelt’ webinar

    I recently gave a Redgate University webinar with Chris Kerswell and Thomas Walsh. Giving webinars as a team is terrific, as it shows how we work at Redgate. Chris is a Sales Engineer, Tom is a Software Engineer, and I’m a DevOps Advocate. Behind the scenes, we often work together across these groups to solve

  • Forums

    SQL Compare Forum

    Compares and synchronizes SQL Server database schemas