Fog Creek Software
Discussion Board




Downsizing from SQL Server to Access

I'm approaching case 1000 in our FogBUGZ system, and we're still running with Jet as the database. Our .MDB file is currently a shade over 30MB. My plan is to upgrade our aging W2K installation to Windows Server 2003 along with SQL Server. This means that FogBUGZ will need to migrate from Jet to SQL Server. No problem there.

What I will have an issue with, however, is one of my customers that has a FogBUGZ login. He has asked that I leave the database in Jet because at some point in the future he may wish to host the FogBUGZ server himself and it would be easier for him to do this if I leave it in Jet.

Having said all that, my question is this: If I proceed with my SQL Server upgrade plans, is there any way I can later take the data back out of SQL Server into Jet should he decide that he does indeed want to host the database himself?

Andrew Lighten
Sunday, February 01, 2004

Sure.  The DTS wizard in Jet will export to Access...

Michael H. Pryor
Sunday, February 01, 2004

*  Recent Topics

*  Fog Creek Home