--- title: "Project Settings (Migration) (SybaseToSQL) | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: sql ms.reviewer: "" ms.technology: ssma ms.topic: conceptual ms.assetid: 82f8857f-7ab1-4738-ab6e-b1e95ea94924 author: "Shamikg" ms.author: "Shamikg" --- # Project Settings (Migration) (SybaseToSQL) The Migration page of the **Project Settings** dialog box contains settings that customize how SSMA migrates data from Sybase Adaptive Server Enterprise (ASE) to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. The Migration pane is available in both the **Project Settings** and **Default Project Settings** dialog boxes. - To specify settings for all SSMA projects, on the **Tools** menu, select **Default Project Settings**, select migration project type for which settings are required to be viewed /changed from **Migration Target Version** drop down click **General** at the bottom of the left pane, and then click **Migration**. - To specify settings for the current project, on the **Tools** menu, select **Project Settings**, click **General** at the bottom of the left pane, and then click **Migration**. ## Date Correction Options |Term|Definition| |--------|--------------| |**Replace unsupported dates**|Specifies whether SSMA should correct dates that are earlier than the earliest [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] **datetime** date (01 January 1753).

To keep the current date values, select **Do nothing**. [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] will not accept dates before 01 January 1753 in a datetime column. If you use older dates, you must convert the datetime values to character values.

To convert dates before 01 January 1753 to NULL, select **Replace with NULL**.

To replace dates before 01 January 1753 with a supported date, select **Replace with nearest supported date**.

**Default Mode**: Do nothing

**Optimistic Mode**: Do nothing

**Full Mode**: Replace with nearest supported date| ## Migration Engine |Term|Definition| |--------|--------------| |**Migration Engine**|Specifies database engine used during Data Migration. Client side data migration refers to SSMA client retrieving the data from the source and bulk inserting that data into SQL Server. Server side data migration refers to SSMA data migration engine (bulk copy program) running on the SQL Server box as a SQL Agent job retrieving data from the source and inserting directly into SQL Server thus avoiding an extra client-hop (better performance).

**Default Mode**: Client Side Data Migration Engine

**Optimistic Mode**: Client Side Data Migration Engine

**Full Mode**: Client Side Data Migration Engine| > [!IMPORTANT] > When the **Migration Engine** option is set to **Server Side Data Migration Engine**, a new Project setting option **Use 32-Bit Server Side Data Migration Engine** is displayed. It specifies whether 32 bit or 64 bit Bulk Copy Program (BCP) utility is used to migrate data. ## Miscellaneous Options |Term|Definition| |--------|--------------| |**Batch Size**|Specifies the batch size used during data migration.

**Default Mode**: 10000

**Optimistic Mode**: 10000

**Full Mode**: 10000| |**Check constraints**|Specifies whether SSMA should check constraints when it inserts data into SQL Server tables.

**Default Mode**: False

**Optimistic Mode**: False

**Full Mode**: False| |**Data Migration Timeout**|Specifies the timeout used during data migration

**Default Mode**: 15

**Optimistic Mode**: 15

**Full Mode**: 15| |**Extended Data Migration Options**|Shows extra data migration options for each table in separate detail tab.

**Default Mode**: Hide

**Optimistic Mode**: Hide

**Full Mode**: Hide| |**Fire triggers**|Specifies whether SSMA should fire insertion triggers when it adds data to SQL Server tables.

**Default Mode**: False

**Optimistic Mode**: False

**Full Mode**: False| |**Keep identity**|Specifies whether SSMA preserves Sybase identity values when it adds data to SQL Server. A value of False causes identity values to be assigned by the destination.

**Default Mode**: True

**Optimistic Mode**: True

**Full Mode**: True| |**Keep nulls**|Specifies whether SSMA preserves null values in the source data when it adds data to SQL Server, regardless of the default values that are specified in SQL Server.

**Default Mode**: True

**Optimistic Mode**: True

**Full Mode**: True| |**On Error**|Stops Data migration when an error occurs. It has three options:

**Stop migration:** Stops data migration operation

**Proceed to next table:** Stops data migration to the current table and proceeds to the next one

**Proceed to next batch:** Stops data migration to the current batch and proceeds to the next one

**Default Mode**: Proceed to the next batch

**Optimistic Mode**: Proceed to the next batch

**Full Mode**: Proceed to the next batch| |**Round fractional part of numbers**|Specifies whether to trim the fractional parts of decimal and numeric data during migration to integer types or display error message if fractional part is non-trivial

**Default Mode**: No

**Optimistic Mode**: No

**Full Mode**: No| |**Sybase Unicode Endian**|Specifies the endian type for the Sybase Unicode strings. The following options can be set for this particular setting:

Little-endian

Big-endian

**Default Mode**: Little-endian

**Optimistic Mode**: Little-endian

**Full Mode**: Little-endian| |**Table lock**|Specifies whether SSMA locks tables when it adds data to tables during data migration. Obtains a bulk update lock for the duration of the bulk copy operation. If the value is False, a lock is set at the row level.

**Default Mode**: True

**Optimistic Mode**: True

**Full Mode**: True| |**Use cursors**|The data is retrieved from source database using cursors if this option is set.

**Default Mode**: False

**Optimistic Mode**: False

**Full Mode**: False| ## Parallel Data Migration |Term|Definition| |--------|--------------| |**Parallel Data Migration Mode**|Specifies the mode used to fork threads to enable parallel data migration. In Auto mode, SSMA chooses the number of threads (10 by default) forked to migrate data. In Custom mode, user can specify the number of threads forked to migrate data (minimum is 1 and maximum is 100). Currently, only client side data migration engine supports parallel data migration.

**Default Mode**: Auto

**Optimistic Mode**: Auto

**Full Mode**: Auto| > [!IMPORTANT] > When the **Parallel Data Migration Mode** option is set to **Custom**, a new Project setting option **Thread Count** is displayed. It specifies number of threads used for data migration.