Pervasive.SQL : How to migrate from Pervasive SQL 2000 to MS SQL Server 2000 or 2005

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by gstenger 0n 24 October 2008

I’m hoping someone might be able to give me some direction here. I have been tasked with taking some client data which was stored in Pervasive SQL 2000 and migrating that over into our own system which is currently in SQL Server 2000 (2005 can be used as well). I have their data which is nothing more than a series of 112 .DAT files. I do not have Pervasive SQL 2000 installed, but I do have MS SQL Server 2000 and 2005 installed. My first goal is to simply get the raw data ported over into SQL Server so that I can at least view the data and try to make some sense of how I can begin mapping it over into our current structure. I had never heard of Pervasive SQL until this project, so I’m at a loss of where to start. Any help would be appreciated.

Learn more about Pervasive.SQL databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting