Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info
Read in English
Read in English
Twitter LinkedIn Facebook Email

Migrating to In-Memory OLTP

  • Article
  • 06/13/2017
  • 2 minutes to read

In this article

This section discusses how to migrate database objects to use In-Memory OLTP.

  • Determining if a Table or Stored Procedure Should Be Ported to In-Memory OLTP

  • Memory Optimization Advisor

  • Native Compilation Advisor

  • Transact-SQL Constructs Not Supported by In-Memory OLTP

  • Implementing LOB Columns in a Memory-Optimized Table

  • Implementing SQL_VARIANT in a Memory-Optimized Table

  • Migration Issues for Natively Compiled Stored Procedures

  • Migrating Computed Columns

  • Migrating Triggers

  • Cross-Database Queries

  • Migrating Check and Foreign Key Constraints

  • Implementing IDENTITY in a Memory-Optimized Table

For information about migration methodologies, see In-Memory OLTP - Common Workload Patterns and Migration Considerations.

See Also

In-Memory OLTP (In-Memory Optimization)
Estimate Memory Requirements for Memory-Optimized Tables

  • Previous Version Docs
  • Blog
  • Contribute
  • Privacy & Cookies
  • Terms of Use
  • Trademarks
  • © Microsoft 2022

In this article

  • Previous Version Docs
  • Blog
  • Contribute
  • Privacy & Cookies
  • Terms of Use
  • Trademarks
  • © Microsoft 2022