Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version 2

changes.mady.by.user Jenni Wallin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Image Modified

When distributing data to an SQL Server table, the following must be taken into consideration:

  • The table must have at least one UNIQUE column.

  • The column reserved for the Transaction ID must be of type bigint.

  • Columns of type UNIQUEIDENTIFIER must be set with a function. Hence, map it to NULL in the agent.

  • Columns with an IDENTITY set, must be mapped to NULL in the agent.

    Note
    titleNote!

    For MS SQL, the column type timestamp is not supported in tables accessed by MZ. Use column type datetime instead.

    See Administrator(3.0) for information about time zone settings.