MySQL Forums
Forum List  »  Oracle

Oracle's Sequence alternatives in MySQL
Posted by: Julián Jorge Sanmartino
Date: December 05, 2022 11:43AM

We are migrating all our applications from OracleDB to MySQL, and we have some concerns. We want to know if MySQl covers the next feature offered by OracleDB:
- Sequences: We use sequences to generate the primary keys of our data, is it possible to do the same in MySQL? We care a lot about the performance when inserting new values, and I've been told that MySQL's auto increment is slower than Oracle's Sequences.

Also, does the MySQL paid version offer support for migrating from oracle to MySQL? Is there a tool to automatically migrate all data?

Options: ReplyQuote


Subject
Views
Written By
Posted
Oracle's Sequence alternatives in MySQL
116
December 05, 2022 11:43AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.