Hi everyone, I have one database on SQL that makes me a bit crazy.
Let's begin from the beginning.
2-3 years ago, a customer changed version from nav 4 no SP to nav 4SP3.
No problems with the migration. After that I took a copy of the db and i restored it on my pc for development purposes.
Time passed and i've had no problems using the database, until I restored this db on Q3 or Q4 of 2008 (indicatively).
during this time I installed/uninstalled some versions of nav.
Anyway, now, when I try to open the db with 4SP3 version (i'm sure it is that version), i receive the typical message for conversion of the db and then i can open it with 4SP3 only (which is the expected result).
My question is: why?
i'm sure the db is 4SP3 and i'm sure my client is 4sp3, too...what's the problem?I can't figure it out ](*,)
thanks in advance
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog0
Answers
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
That's wacked! How would you even know this
You're amazing! =D>
http://www.BiloBeauty.com
http://www.autismspeaks.org
I have just read his blog... ;-)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
kine, you're speaking arabian for me..anyway, my db is sql, i wrote it in a tricky way, i admit let's see what can I do
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
e.g. value 60 means NAV 4.00SP3, but value 63 means NAV 4.00SP3 Update 6 and newer. It meas, still NAV 4.00SP3, but different update, and this is I think your source of your craziness ... ;-)
Complete table of versions I have is this:
If there is no value, it means that it is same with previous version or it is unknown for me. The Min and Max file version is version of the .exe file (not accurate, only aproximate).
By this table you are able to find out which version of NAV is the .exe file and which version of DB is the SQL or .fdb. After that it is easy to open correct version of nav for selected DB... ;-)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
now, another question...what if i change the value manually?I mean, i don't think it's a good thing to do, but i'd like to know what are the problems in doing this...
and about fdb, do you mean to open the database with an hex editor: right clicking, open with...?(where can i find an hex editor?)
thanks a lot to share your knowledge, this forum trains me more than working?
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
=D>
now i try to modify it :twisted:
bwahahahah! it works!!
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
The HEX editor means some HEX editor you can download from internet and which is able to show you the file in HEX format. E.g. Total commander viewer (F3, and select the Options -HEX, there is position on the left and values in the table for each byte in the file).
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
I have now 3 ways to work
1. i change the value from 60 to 63, i do my work (which is delete "non setup" data) and then i change the value back to 63: could this be dangerous?
2. I retrieve in some way this old build of nav and then work (best solution but hard to do as i don't have a VPN to the customer and i don't know how to get the client from them)
3. delete data directly from sql, knowing the exact tables i have to clear. (also this solution is a bit risky, as business logic is not executed, but i don't think it's a problem as i am only deleting data)
can you please help me to choose the best solution? thanks in advance
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
You do not need to work on same version as client. It is needed only when you want to replicate some error your client have. You can work with newer client without problems, the objects will be compatible (if you will use e.g. newer NAV 4.00SP3 client...)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I thought that it should be better to do a tech upgrade, but i have to determine if it is an applicable solution. (i don't know anything about licensing and so on). I'll check it with salesperson.
EDIT: approved, i'll go for the tech upgrade.
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
this is the situation: i got a backup from a customer, then i clear unnecessary tables, and then i bring this backup on another database (it's something like a new company which starts from the old company's data)
summary:
old backup (it's a sql backup) -> old nav client, then i open the old restored db with my new luminous and beautiful client, i convert it and i restore on the new database the cleaned backup. after that i install the new versions of nav client on my customer's pcs (hope to find some beautiful girl 8) )
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog