Hello hibernate community. I'm working currently on a Oracle to SQL Server Migration of a Java application that uses Hibernate for a very large number of queries.

I am not a professional DBA by any means, specifically an engineering intern. So with that in mind, any additional resources I could read that you know of would be very helpful.

Because there is a large number of queries, we want to test the changes of individual classes of the application that use the hibernate structure. As such, it is necessary to keep the Oracle9iDialect for all files that haven't been converted yet while using the SQLServerDialect2008 for files that have been worked on. This is due to database changes required since the application uses a large number of sequences to generate unique ids.

So I'm basically asking is there anyway to Override the default SQL dialect hibernate uses to generate the id's for individual mapping files? How can hibernate implement multiple SQL dialects?

If any more information is required to answer this question let me know, and I'm sorry if I dont make sense. Thanks in advance.