Striim Migration Service for Google Cloud Documentation

Set up the SQL Server source

  1. If it is not running already, start SQL Server Agent (see "Start, Stop, or Pause the SQL Server Agent Service" on msdn.microsoft.com). This service must be running for the CDC streaming migration application to read the source data. If it is not running, you will see an error similar to the following in striim.server.log:

    2017-01-08 15:40:24,596 @ -ERROR cached5 
    com.webaction.source.tm.MSSqlTransactionManager.getStartPosition 
    (MSSqlTransactionManager.java:389) 2522 : 
    Could not position at EOF, its equivalent LSN is NULL   
    
  2. Enable change data capture on the databases using the following commands:

    USE <database name>
    EXEC sys.sp_cdc_enable_db
  3. Create a SQL Server user for use by SMSGC. This user must use the SQL Server authentication mode, which must be enabled in SQL Server. (If only Windows authentication mode is enabled, SMSGC will not be able to connect to the SQL Server source.)

  4. Grant the SMSGC user the db_owner role for each database to be read using the following commands:

    USE <database name>
    EXEC sp_addrolemember @rolename=db_owner, @membername=<user name>