LIVE DB converted from Nav Sp1 to NAv 2009 [Very Urgent]

supportnav

We are having one LIVE database in Navision SP1 (SQL database)..

Some one has wrongly opened in the Navision 2009 and its got converted..


Now its make any problem if they continue with Nav 2009 otherwise any other way to retrive back to Nav 4 SP1 ??????

its very urgent..

Saalek

Hi

Try to do a backup from your NAV2009 database and restore it in NAV 4.XX

Bye

Waldo

Well,
Very tricky and very unsupported.

The conversion means you're working with a different SIFT technology ...

Here are a few tips you can work with:
This blogpost is an (again .. unsupported) way to go back to the old SIFT: http://dynamicsuser.net/blogs/stryk/arc ... g-nav.aspx
Furthermore you could use the table $ndo$dbproperty and field "databaseversionno", which is 140 for NAV2009 and 95 for 5.0SP1.

What I would try out is:
1) go back to 5.0SP1
2) Jorg Stryk's blog post
3) go back to 4.X

But may be it's easier to do a runtime upgrade to NAV2009 ... (at least if you're on SQL Server 2005/2008 or Native).

canadian_bacon

The good news is that the objects are still 4.0. So just create a 4.0 database, export all the objects in the 2009 database and import into the 4.0 database. Now, backup the nav2009 database but make sure to UNCHECK "application objects" and "data common...". Now, just restore the backup in 4.0

devu_13

Hi
If Very Unsupported thing so Plz Take Backup And Restore On 4.0
I Hope you Got Better result

imurphy

Would there be any downside to just installing the Nav 2009 classic client on all PC's? As a solution it would seem to be the simplest. The codebase remains the same so functionality should not change. The only effect will in the way the new client uses SQL with the consequent effect on performance. Are there other major differences?

Maybe someone with more knowledge on the subject could comment? Bad idea? Good Idea?

Ian

Waldo

In my opinion: good idea, if you're running the native server, or SQL Server 2005 or 2008.

supportnav

First they are not ready to pay for Nav 2009 License upgradation as well vise versa..

we are running on SQL server 2005..

Today i restored latest backup and asked them to continue.....

Waldo

License upgrade? Don't they pay maintenance?

David_Singleton

supportnav wrote:

Today i restored latest backup and asked them to continue.....

=D>

Always this is the best and safest solution if it is acceptable.

supportnav

Still now there is no problem...... it working good...

its only safe when taking daily backup.....


Warm Thanks.....