13 lines
885 B
Markdown
13 lines
885 B
Markdown
# MS SQL Server Migration Guide
|
|
|
|
## Upgrading to 2.0.0
|
|
|
|
This version removes the Airbyte "raw" tables introduced in version 1.0.0. As such,
|
|
any attempt to upgrade an existing connection will fail unless a "truncate refresh" is first executed. It is
|
|
recommended that you should create a new connection using this upgraded destination and delete the existing
|
|
connection and generated "raw" tables in the destination after performing a successful sync via the new connection.
|
|
|
|
In addition to removing the Airbyte "raw" tables, this version also introduces a new insert mode: bulk insert via
|
|
Azure Blob Storage. This mode is only supported with Microsoft SQL Server 2017 (14.x) and newer and in scenarios where
|
|
the database instance has access to Azure Cloud. This is a net-new configuration option and may be opted in to at any point after upgrading to
|
|
the new connection version. |