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

    Automatically filling your SQL Server test databases with data

    Phil Factor provides a simple PowerShell script that you can use to automate data provisioning for test databases, during the database development cycle.

  • Event

    SEACON 2018 (The Study of Enterprise Agility Conference)

    SEACON is THE Enterprise Agility conference that brings business and technology together, and Redgate are pleased to be taking part as one of the sponsors. Following the sold out conference in 2017, the 2018 edition will again host FinTech practitioners and Thought Leaders in Enterprise Transformation, Entrepreneurial Leadership, Agile , DevOps, Cloud and Fintech.

  • Article

    Source controlling your database permissions

    How to use a combination of database roles, along with rules, filters and post deployment scripts in SQL Source Control, to add the required users to the correct role, for each database.

  • Community event

    SQLSaturday Johannesburg

    SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorship. Please register soon as seating is limited, and let friends and colleagues know about the event. Redgate will be there as one of the

  • Forums

    SQL Compare Forum

    Compares and synchronizes SQL Server database schemas