i am in the process of exporting data from a Pervasive database to an SQL Server 2008 database.
In one table there is an identity column. I need to keep the same identity value in the new table in SQL Server when i do the import.
What do i need to do?
Since SQL Servers import wizard does not support Pervasive (very well) i will be writing a program that reads from the Pervasive database and inserts into the SQL Server database.