Location: Step By Step Procedures

Discussion: moving AirVision to a new PCReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 2 posts

BDutcher
moving AirVision to a new PC
Aug 17 2011, 11:03 AM EDT | Post edited: Aug 17 2011, 11:03 AM EDT
The backup/restore procedures won't work between PC's. The SQL server error message is that the backup database set holds the backup of a different database than the current (that would be my new) AVDATA database.

So how do we move AirVision to a new PC? Maybe I will delete the current (new / empty) database and see if that will work.

Thanks,
Ben Do you find this valuable?    
Keyword tags: None

BDutcher
1. RE: moving AirVision to a new PC
Aug 17 2011, 12:52 PM EDT | Post edited: Aug 17 2011, 1:07 PM EDT
Answer is indeed to delete the new & empty AVDATA database (or just don't create it during the initial installation of the SQL server.) Then restore the backup to AVDATA and it will create a new and populated database. I haven't fully tested the new one, but it looks OK so far.

FYI, I am still using SQL Server 2005 Express, and AirVision and the SQL server share the same PC. I migrated the setup from a Windows 7 PC to a Windows XP box.

There is a DUH! moment were Rena' pointed out that I probably had never clicked on the "overwrite exisiting database" option! Maybe none of this discussion would have been necessary if I had!

Ben Do you find this valuable?