Class StretchDatabaseSchema.RemoteDataArchiveTable
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
Stretch Database Catalog Views - sys.remote_data_archive_tables
Applies to: √ SQL Server 2016 (13.x) and later
Contains one row for each remote table that stores data from a Stretch-enabled local table.
[Table(Schema = "sys", Name = "remote_data_archive_tables", IsView = true)]
public class StretchDatabaseSchema.RemoteDataArchiveTable- Inheritance
-
StretchDatabaseSchema.RemoteDataArchiveTable
- Extension Methods
Properties
FilterPredicate
The filter predicate, if any, that identifies rows in the table to be migrated. If the value is null, the entire table is eligible to be migrated.
For more info, see Enable Stretch Database for a table and Select rows to migrate by using a filter predicate.
[Column("filter_predicate")]
[Nullable]
public string? FilterPredicate { get; set; }Property Value
IsMigrationPaused
Indicates whether migration is currently paused.
[Column("is_migration_paused")]
[Nullable]
public bool? IsMigrationPaused { get; set; }Property Value
- bool?
IsReconciled
Indicates whether the remote table and the SQL Server table are in sync.
When the value of is_reconciled is 1 (true), the remote table and the SQL Server table are in sync, and you can run queries that include the remote data.
When the value of is_reconciled is 0 (false), the remote table and the SQL Server table are not in sync. Recently migrated rows have to be migrated again. This occurs when you restore the remote Azure database, or when you delete rows manually from the remote table. Until you reconcile the tables, you can't run queries that include the remote data. To reconcile the tables, run sys.sp_rda_reconcile_batch.
[Column("is_reconciled")]
[Nullable]
public bool? IsReconciled { get; set; }Property Value
- bool?
MigrationDirection
The direction in which data is currently being migrated. The available values are the following.
1 (outbound)
2 (inbound)
[Column("migration_direction")]
[Nullable]
public byte? MigrationDirection { get; set; }Property Value
- byte?
MigrationDirectionDesc
The description of the direction in which data is currently being migrated. The available values are the following.
outbound (1)
inbound (2)
[Column("migration_direction_desc")]
[Nullable]
public string? MigrationDirectionDesc { get; set; }Property Value
Object
objects (sys.objects)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }Property Value
ObjectID
The object ID of the Stretch-enabled local table.
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }Property Value
RemoteDatabaseID
The auto-generated local identifier of the remote database.
[Column("remote_database_id")]
[NotNull]
public int RemoteDatabaseID { get; set; }Property Value
RemoteTableName
The name of the table in the remote database that corresponds to the Stretch-enabled local table.
[Column("remote_table_name")]
[Nullable]
public string? RemoteTableName { get; set; }