SQL 6.5 and SQL 7.0 on same machine

I have SQL 6.5 running just fine on my development server and 6.5 on my production server (which I will not tinker with) but I create summary tables on the development server and transfer them to the production server, this is what I do not want to damage. But, I want to know if I can install Beta 3 to run concurrent with 6.5 or somehow operate 6.5 from 7.0 without damaging the ability to restore 6.5 databases and transfer summar tables to another 6.5 server. I`m asking this because monthly I get a database dump, restore it on my side, do my hashing of the data, and then transfer summary talbes to another server where it`s available to be queried from the web with Cold Fusion.

Please let me know.

P.S. I have 7.0 beta 3 running at home and found that it had removed to 6.5 application group, but when I start 7.0 manager it shows the 6.5 server but I cannot access it for some reason. I didn`t upgrade any databases.

You should have an option on your start menu called something to the effect of switch sql server 6.5 (or 7.0) It works pretty well. When you switch, you`ll get a warning if the program that puts the status indicator in the system tray is still running (I forget the name of the program) but you can leave the program running and the switch works fine. The indicator works well for 6.5 or 7.0. The switch will stop SQL server, change the services for the opposite version, change the start menu, and leave SQL server stopped. You`ll have to manually start the service.

On 7/17/98 11:42:57 AM, Richard Nunez wrote:
> I have SQL 6.5 running just fine on my development server and 6.5 on my
> production server (which I will not tinker with) but I create summary
> tables on the development server and transfer them to the production
> server, this is what I do not want to damage. But, I want to know if I can
> install Beta 3 to run concurrent with 6.5 or somehow operate 6.5 from 7.0
> without damaging the ability to restore 6.5 databases and transfer summar
> tables to another 6.5 server. I`m asking this because monthly I get a
> database dump, restore it on my side, do my hashing of the data, and then
> transfer summary talbes to another server where it`s available to be
> queried from the web with Cold Fusion.

Please let me know.

P.S. I
> have 7.0 beta 3 running at home and found that it had removed to 6.5
> application group, but when I start 7.0 manager it shows the 6.5 server but
> I cannot access it for some reason. I didn`t upgrade any databases.