is it possible to create a stanalone database from a navison 3.7 running on SQL ? ie backup the database locally, create a new blank empty database (locally) and restore the backup into this new database. i know that it is possible in native, but i have never tried in sql. cheers
Yes, it is. You can use MSDE as storage for your local database. [edit] Tip: If you download the SQL Server evaluation version (almost 300 MB for a 90 day trial, if I remember properly), you can install only the Enterprise Manager part of it (which will not expire) and get the administration capabilities of SQL Server on the Desktop Engine version.
cheers, well ive just tried backing up and i get the error message “TableData 150014 does not exist”. is there a .pdf or something that goes through the process, (im looking for it as we speak).
I don’t know TableData 150014. Isn’t that 15014 and maybe it’s something from the GB version?
150014 = “Sesseion (SQL)” something to do with the client monitor.
A colleague of mine has done exactly what you are attempting but he had no such error, sorry for not being more helpful. Maybe I will try it also - for academic reasons… [:D]
well i was trying to create a backup from a development database, and the error was occuring. so just tried it from the “live” database and it works fine. thanks
It means you have this object in the object table (it is part of the troubleshooting guide tools), but do not have the SQL View in the database which is created outside of Navision.