bas_idgen_seq

[customaware]

Ok.... I am a bit confused... which is more often than not the case...

I have an app in it's own DB Demo1 and the app is full of data and working fine.
I now want to migrate ALL the data in that Demo1 BS to a new BS called Demo2

I create the new BS, Demo2 and import the BSV and publish it. All the tables are created.

I then use Navicat to Transfer ALL the data from Demo1 to Demo2

Seemed to be ok but some strange things were happening. I suspected that it might be something to do with the bas_idgen_seq table.
In Demo1 the next_not_cached_value = 45001
In Demo2 the next_not_cached_vlaue = 1001

This would appear to be the root of the issue I would have thought.... Data already exists with an ID of 45000 then the Demo2 app next_not_cached_vlaue should be at least greater than that.

So I would imaging that I need to update the next_not_cached_value in the Demo2 bas_idgen_seq table. However, I cannot change it in the BD.

Any pointers, tips, ideas would be certainly appreciated.

TIA

[BLOMASKY]

1st, I only know the implementation on MSSQL, so assuming you are using that.

Each database has a SEQUENCE (prior was just a view to connect ALL dbs to the bas_idg_gen in the aware or awaretest db.

You can easily reset the next sequence #

ALTER SEQUENCE BAS_IDGEN_SEQ RESTART WITH ######

Bruce

[customaware]

Thanx Bruce.

Using MariaDB but should work. Will try out and advise.

[customaware]

Hi Bruce,

That worked a treat on MariaDB.

Thankyou.

Was not the cause of my original problem as I though it might be but have found that also, so, all good.