I wouldn't suggest having a single remote database synchronize using two different script versions. Defining synchronization scripts for all tables in 'v2' in the consolidated database and having newly created remote databases (with the extra column) synchronize using the 'v2' script version is the correct way to handle this.

If a remote database is using the "old" schema (i.e. updated table does not have the extra column), it should synchronize using the "old" script version ('v1' in your example). If a remote database is using the "new" schema (i.e. updated table does have the extra column), it should synchronize using the "new" script version ('v2' in your example).

The START SYNCHRONIZATION SCHEMA CHANGE (and subsequant STOP SYNCHRONIZATION SCHEMA CHANGE) command is used when you alter the schema of the remote database and move to a different script version.

Reg

Aside : Copying a script version in a consolidated database is easy. I've attached a simple SQL Anywhere stored procedure that makes a copy of a script version in an SQL Anywhere consolidated database. After you've copied 'v1' to 'v2' modify the scripts for my_updated_table in 'v2', and you're ready to go.

create procedure CopyScriptVersion ( in @orig varchar(128), in @dest varchar(128) )
begin
    declare cur_table cursor for 
        select event,table_name,script_language,script 
          from ml_table_scripts
         where version = @orig;
    declare cur_conn cursor for 
        select event,script_language,script 
          from ml_connection_scripts
         where version = @orig;
    declare cur_col cursor for 
          select mlt.name, mlc.name, mlc.type
            from ml_column mlc, ml_script_version mlsv, ml_table mlt
           where mlsv.version_id = mlc.version_id
             and mlt.table_id = mlc.table_id
             and mlsv.name = @orig
        order by mlt.name, mlc.idx;
    declare @event       varchar(128);
    declare @table_name  varchar(128);
    declare @script_lang varchar(128);
    declare @column_name varchar(128);
    declare @type        varchar(128);
    declare @script      long varchar;

open cur_table;
    fetch first cur_table into @event,@table_name,@script_lang,@script;
    while ( sqlcode = 0 ) loop
        call ml_add_lang_table_script( @dest, @table_name, @event, @script_lang, @script );
        fetch next cur_table into @event,@table_name,@script_lang,@script;
    end loop;
    close cur_table;

open cur_conn;
    fetch first cur_conn into @event,@script_lang,@script;
    while ( sqlcode = 0 ) loop
        call ml_add_lang_connection_script( @dest, @event, @script_lang, @script );
        fetch next cur_conn into @event,@script_lang,@script;
    end loop;
    close cur_conn;

open cur_col;
    fetch first cur_col into @table_name, @column_name, @type;
    while ( sqlcode = 0 ) loop
        call ml_add_column( @dest, @table_name, @column_name, @type );
        fetch next cur_col into @table_name, @column_name, @type;
    end loop;
    close cur_col;

end;