cancel
Showing results for 
Search instead for 
Did you mean: 

How do I get the "timeline" value when rebuilding a pre-v17 database for use with SQL Remote?

VolkerBarth
Contributor
1,224

This is a question raised by @Sako in a comment on the following FAQ:

Is the option -ft mandatory? Since I am migrating from SQL10 to SQL17, and since DBLOG.EXE in SQL10 didnt support -ft option, then I don't know which value to assign this option.

Background: The description to Rebuilding databases involved in synchronization or replication (manual) tells that in step 3, the output of DBTRAN on the "old" database has to be noted, including the "timeline" value, to apply those values to the new database in step 8.

AFAIK, that value is only listed for v17 databases, both with DBTRAN and DBLOG, such as:

SQL Anywhere Log Translation Utility Version 17.0.10.6057
Transaction log "demo.log" starts at offset 0005206932
Current timeline GUID: 3d08c867-4f32-4113-886c-b232fb0280f5
Current timeline UTC creation time: 2018-09-03 07:23:53.210000+00:00
Current transaction log GUID: 00000000-0000-0000-0000-000000000000
 100% complete
Transaction log ends at offset 0005219754

However, DBTRAN and DBLOG (even the v17 utilities) do not list a timeline for v16 and older databases.

Does it mean specifying the "timeline" value can be omitted in step 8 when rebuilding pre-v17 databases?

Accepted Solutions (1)

Accepted Solutions (1)

johnsmirnios
Advisor
Advisor

If a log supports timelines, v17 dblog/dbtran software will show the timeline info; otherwise, it will not. If the log format does not support timelines, you do not need to specify -ft.

Note that v16 also supported timelines (although it might only have been introduced in later version of v16).

VolkerBarth
Contributor
0 Kudos

Hm, my 16.0.0.2798 databases don't show timelines...and those are using the latest build (and were created with 16.0.0.2546). But of course, your answer helps: If they don't show timelines, I do not need to specify those:)

johnsmirnios
Advisor
Advisor

Sorry. I looked deeper and timeline support was only enabled for IQ in the v16 code line, not SQLAnywhere.

Baron
Participant

In my last test I ignored -ft while overtaking offsets from SQL10 in SQL17, and I have so far no problems

Answers (0)