I had create and application using VB6 and Crystal Report 10. My database is SQLServer 2000.

I had used connection wizard while putting the field into the report and had use 'DataEnviroment' Tables through connection to put field into the report.

Now, I want to change the database every thing should be same except the name, How can I achieve that. I had placed many many filed and reports so its not possible to replace each filed at one time

Actually, Its an accounting software I want to run two companies on same computer so for which I want to replicate the database with another name and want to make connection with them.