Skip to main content

SQL Server runtime considerations

Runtime considerations when using MSJet

  • Debug messages for the Windows-native portion of the adapter may appear in striim/logs/striim_mssqlnativereader.log rather than in striim.server.log.

  • If utilizing both replication and CDC, you must continue to keep CDC jobs enabled.

  • Known issue DEV-27132: When an MSJet application is deployed or running, do not perform any operations, such as ALTER TABLE ... REBUILD WITH or ALTER INDEX ... REBUILD WITH, that will change tables' partition IDs, since that may result in data loss.

  • Known issue DEV-44032: If you drop a table and re-create it, you must manually enable CDC for the new table using the following command. Replace <schema name> with the name of the schema containing the table, <table name> with the name of the table, and <Striim role> with the name of the Windows or SQL Server user created for use by Striim as described in Configuring SQL Server to use MSJet.Configuring SQL Server to use MSJet

    EXEC SYS.sp_cdc_enable_table @SOURCE_SCHEMA = '<schema name>', @SOURCE_NAME = '<table name>',
  @ROLE_NAME = '<Striim role>'

  • Known issue DEV-53082: When the user does not have the sysadmin role, you must use the following command to manually enable CDC for each table to be read and for each new table added in the future. Replace <schema name> with the name of the schema containing the table, <table name> with the name of the table, and <Striim role> with the name of the Windows or SQL Server user created for use by Striim as described in Configuring SQL Server to use MSJet.Configuring SQL Server to use MSJet

    EXEC SYS.sp_cdc_enable_table @SOURCE_SCHEMA = '<schema name>', @SOURCE_NAME = '<table name>',
  @ROLE_NAME = '<Striim role>'

Reading from multiple databases with a single Forwarding Agent

Each MSJet instance can read from only a single database. To read from multiple databases, starting in Striim 5.0 you may run multiple instances of MSJet in a single Forwarding Agent (see Striim Forwarding Agent system requirements).

MSJet limitations

  • Tables with XML columns are not supported.

  • Reading from secondary databases is not supported.

  • Reading from AG listeners is not supported.

  • Reading from backups is supported only if they are accessible only in the location where they were taken.

Runtime considerations when using MS SQL Reader

If you will no longer use an app in which MS SQL Reader's Auto Disable Table CDC property is False, when stopping it for the last time, do the following in order to delete the tables that will no longer be used for CDC (see Learn / SQL / SQL Server / Change Data Capture Tables (Transact-SQL)):

  1. Stop and undeploy the application.

  2. In the Flow Designer, edit the MS SQL Reader, set Auto Disable Table CDC to True, and save the change.

  3. Redeploy and start the application.

  4. Stop, undeploy, and drop the application.