This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hello! I have a little problem. I'm transfering data from a oracle database to mssql server 2012. There was a problem with sequence use in mssql. In attempt to pull out the following sequence value exception - The SqlServer2008 data provider does not support sequence number identity generation falls out. What offers according to the solution of the matter are? p.s. sorry for my bad english :) |
|
|
|
|
Sequence identity generation in LightSpeed only works on Oracle and PostgreSQL at the moment. You'll need to switch to KeyTable: FYI, SQL Server 2012 added "CREATE SEQUENCE ..." but I haven't seen any SQL Server 2012 features announced by Mindscape yet. Any news, guys? |
|
|
|
|
i think we need some new sql provider for mssql 2012 =) |
|
|
|
|
We will be adding a SQL Server 2012 provider with LightSpeed 5 so SEQUENCE support will be added with that for 2012.
|
|
|
|
|
how soon the new version will be released? |
|
|
|
|
Our current plans are to release 5.0 towards the end of the year. As with previous releases we will be putting out beta builds a month or so prior.
|
|
|
|
|
thanks a lot for information |
|
|
|
