Has anyone succeeded in exporting objects from a database that is hosted on Azure SQL?
(I can get it to work from a database installed on a sql server on e.g. the same server. There I can omit user/pass/server because its on the default sql instance.)
I use this powershell command:
Export-NAVApplicationObject -DatabaseName mydb -Path C:\export\codeunit80-84.fob -DatabaseServer mydbserver.database.windows.net -Username dbadmin -Password password -Filter 'Type=Codeunit;Id=80..84' -LogPath C:\export
the dbadmin user is the primary one created with the azure sql server so has full rights to every database.
I'm exporting from a demo cronus NAV2016 DB, using a server with DAN (danish) set as keyboard layout.
When running the command I get the popup box with the following text and just an OK button to press.
'No' er ikke en valgmulighed.
Følgende indstillinger er tilgængelige:
and the error message in the console after pressing OK:
Export-NAVApplicationObject : !At line:1 char:1+ Export-NAVApplicationObject -DatabaseName mydb -Path C:\export\codeun ...+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Export-NAVApplicationObject
Have a great day, Erik
In reply to Erik P. Ernst:
Thanks Erik Sorry for the late reply but deleting the .zup file really did fix the problem :) I was able to export using the DE client that is in Danish before I deleted the .zup file but it still must have had some settings that clashed.