Search code examples
sql-serversql-server-2008pervasivepervasive-sql

How to migrate Pervasive database to SQL Server 2008?

I have a database that runs on Pervasive Control Center Version 11.30.051.000. I want to copy that entire database to a SQL server database bs I dont want to use Pervasive anymore.

Solution

  • You can use a tool like the "SQL Server Import and Export Wizard" to copy the data. You might have to change data types as there are data types supported by Pervasive PSQL that aren't supported by SQL Server (and vice versa).

    Once you copy the data, you might need to re-write your application to call the SQL Server database instead of the Pervasive database.