AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: John Racars on February 19, 2010, 11:37:55 AM

Title: Route database
Post by: John Racars on February 19, 2010, 11:37:55 AM
Hi All,

Is it possible to copy (by SQL) my route database from the "old" version 3.13 in to the "new" 4.x 3D version?

I think it is not recommended to copy the old "Navdata" into the new because I see other diffrences.

Thank you in advance for any help!
Title: Re: Route database
Post by: tarbat on February 19, 2010, 11:49:44 AM
I simply used my old navdata and mylog databases from the previous version - no problems that I can see.  What "other differences" do you mean?

I guess if you really want to, you could export the route data from navdata using SQLite Maestro, and then import that into the 4.03 navdata database.
Title: Re: Route database
Post by: Allocator on February 19, 2010, 11:56:06 AM
I've copied my old MyLog.db3 and Navdata.db3 (and logo's, flags, outlines and D008.dat) across to the 3D version without any problems.
Title: Re: Route database
Post by: John Racars on February 19, 2010, 11:56:53 AM
What "other differences" do you mean?

Hi Tarbat,

I see there is a "new" table "anlv_photo_asdi"......
Title: Re: Route database
Post by: DaveReid on February 19, 2010, 12:08:57 PM
I guess if you really want to, you could export the route data from navdata using SQLite Maestro, and then import that into the 4.03 navdata database.

You could indeed, but there would be no point.

The NavData.db3 database shipped with RadarBox 3D is identical to that shipped with V3.13, so you have nothing to lose by simply copying your existing NavData.
Title: Re: Route database
Post by: DaveReid on February 19, 2010, 12:10:20 PM
I see there is a "new" table "anlv_photo_asdi"......

That table is also in V3.13.
Title: Re: Route database
Post by: tarbat on February 19, 2010, 12:11:28 PM
You could indeed, but there would be no point.

Unless, like John, you've made lots of updates to your routes table, and don't want to lose them!!
Title: Re: Route database
Post by: DaveReid on February 19, 2010, 12:19:03 PM
You could indeed, but there would be no point.

Unless, like John, you've made lots of updates to your routes table, and don't want to lose them!!

John has made lots of updates to his V3.13 routes database.

V4.03 doesn't have any routes that weren't also in V3.13

Ergo John can safely copy his V3.13 routes table, in fact the entire NavData database, to his V4.03/3D installation, without losing anything.

QED.
Title: Re: Route database
Post by: John Racars on February 19, 2010, 12:29:32 PM
That table is also in V3.13.

Not with me and it is gone now in the new 4.x version but the program runs anyway.  How do I get that table "anlv_photo_asdi" back?
Title: Re: Route database
Post by: DaveReid on February 19, 2010, 12:56:53 PM
How do I get that table "anlv_photo_asdi" back?

I wouldn't worry about it, John.  

I don't know what, if anything, it's used for (AirNav?) and anyway that table only has 159 rows and 3 columns: CO (ICAO airline designator), AT (aircraft ICAO type code) and AR (aircraft registration).

And some of those values are invalid :-)