mibuso.com
Home› NAV Three Tier

Is there a way to restore a native backup in NAV 2013 R2

hklemphklemp Member Posts: 4
edited 2013-10-28 in NAV Three Tier
Hello,

in NAV 2013 Development Environment under tools there was the option to backup\restore a native backup,
but in NAV 2013 R2 this option is missing.

Is there a way to restore a native backup in NAV 2013 R2?

Comments

  • lvanvugtlvanvugt Member Posts: 774
    You're right, it's notthere and nothing mentioned about it in the What's New document. I first thought something would be mentioned about using some PowerShell cmdlet, but nothing.
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    yes, we need to restore using Powershell Cmdlets like
    New-NAVDatabase -FilePath <DatabaseBAKfile> -DatabaseName <MyNavDatabase> -DatabaseInstance <DatabaseInstance> DatabaseServer <DatabaseServer> ServiceAccount <ServiceAccount>

    <DatabaseBAKfile> so we need a SQL Backup file (BAk) for this.

    If you have an earlier version, such as Microsoft Dynamics NAV 5.0 or Microsoft Dynamics NAV 4.0, you must first upgrade that version to Microsoft Dynamics NAV 2013.

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • lvanvugtlvanvugt Member Posts: 774
    So no way of making a company back up?
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
  • hklemphklemp Member Posts: 4
    In NAV 2013 R2 you have a new powershell command to copy a company.
    See http://msdn.microsoft.com/en-us/library ... 3(v=nav.71).aspx
  • lvanvugtlvanvugt Member Posts: 774
    hklemp wrote:
    In NAV 2013 R2 you have a new powershell command to copy a company.
    See http://msdn.microsoft.com/en-us/library/dn466413(v=nav.71).aspx
    Thanx!
    The link wasn't fully working. Have fixed it in the quote.
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    If you want to copy the company from same database then you can simply do it in RTC

    Go to CRONUS Nederland BV/Departments/Administration/IT Administration/General/Companies
    1.Select the Company which you want to Copy.
    2.Click Copy
    3. Enter New Company Name
    4. Click OK

    Done! Your New Company is ready.

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • jglathejglathe Member Posts: 639
    Hi,

    ... still shaking my head in bewilderment... Frankly, I don't think this is a good idea. A .fbk was not perfect, but it was a good way for a backup and a clean rebuild. This is now nearly impossible. For example, how do you change the collation of a NAV database now? And regarding these PowerShell cmdlets... reinventing the wheel, anyone? Why so complicated commands for things you have to do often? I don't get this. Sounds all like a mighty ego-trip of somebody.

    with best regards

    Jens
  • tinoruijstinoruijs Member Posts: 1,226
    Microsoft; Why not just create menu-items in the development enviroment for recurring tasks?
    Stupid Powershell scripts..
    :thumbsdown: :x
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • vremeni4vremeni4 Member Posts: 323
    I still cannot find a way to copy a company from database e.g. TEST into a database e.g. LIVE.
    Copy-NAVCompany only copies the company on the same instance.

    It looks like this is only possible if multi-tenancy is enabled.

    Thanks.
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    Probably the best option is the back-up and restore a SQL back-up and delete the companies you don’t need :D

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • jglathejglathe Member Posts: 639
    mohana_cse06 wrote:
    Probably the best option is the back-up and restore a SQL back-up and delete the companies you don’t need

    This is ridiculous. One has to ask if the people responsible for this crap even have a clue how NAV gets used. This way it surely won't for much longer.
    One real-world example: There are companies who use the consolidate function in NAV. You use a separate company to do your consolidation. In the standard functionality makes it really to botch up a step. The best way out is often a restore of just this company into the NAV database (containing several "real" companies, in my case around 200). With 2013R2 this is definitely out. If you can't mae a backup/restore of a company, you have a very important feature missing. And no, copying a company doesn't suffice.

    with best regards

    Jens
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    That is the the reason Multi Tenancy came.
    we can use new tenant and copy a single company from mulatiple companies.

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • jglathejglathe Member Posts: 639
    Hi Mohana,
    mohana_cse06 wrote:
    That is the the reason Multi Tenancy came.
    we can use new tenant and copy a single company from mulatiple companies.
    I'm afraid it isn't. This may be a workaround, in the best of all cases. I'm sure it will be difficult to explain to a single customer that he needs a multi-tenant setup just to have the features he already paid for. As I said, this is ridiculous.

    with best regards

    Jens
  • vremeni4vremeni4 Member Posts: 323
    I think I watched all videos released by Microsoft regarding multi-tenancy, and spend the last three days testing and experimenting.
    As far as I can see there is no way to copy a company from one database into another if you do not use multi-tenancy.

    Possible options:
    1. Use RapidStart Services to export company from one database, import the configuration package in the second database and import the package. This is very time consuming. :-(
    2. To write a tool in C# that exports all Company tables in a file and import them back in SQL. In other words to reimplement fbk functionality.

    In my opinion this is a big step backwards. Frankly speaking I am heavily disappointed.

    To use multi-tenancy only to be able to copy companies between database is just absurd.

    By the way to install and setup the multi-tenancy environment is not simple at all. There are also bugs in the cmdlet, e.g. you need to dismount a tenant every time when you want to add a company to the tenant.

    Multi-tenancy makes sense for Cloud solution not for a standard implementation.

    I would be grateful if someone could confirm these findings.
    Thanks.
  • deV.chdeV.ch Member Posts: 543
    I agree that it is totally stupid to be forced to install a multi-tenant environment just for a company backup / restore.
    But guys why do you complain about powershell? What is wrong with beeing able to automate nav? This is a great feature and it can really speed up your tasks!
    Why all the complaints about keyboard shortcuts not working anymore (from classic to rtc) or the UI of the RTC, and then comes a great feature which enables you to control everything from the command line, and you rant about it?

    Sorry but that is just lame...

    command line is awesome!
    My Blog
  • paurolapaurola Member Posts: 43
    It took me very long to get used to the idea, that Microsoft wants us to do things in the GUI. Finally I gave up, even though I still use the good old DOS commandline every now and then.

    I just wonder what has happened in MS, some examples here:
    Setting upt the NAV2009 NST:s with the commandline utility SC - nothing difficult there, just many parameters that can go wrong. Luckily the Tegos guys came up with a GUI and MS had to follow.

    Then, how about the the SPN:s... yet another commandline task that would have needed a simple GUI with somekind of Intellisense or options. And finally, moving administrative tasks to PowerShell! I just cant believe this. For all these years we have been hearing MS talk about the "great user experience" and benefits of a graphical user interface. Take a look at the Windows 8 UI - how does that match with PowerShell...

    It is of course good to have a scripting language and the option to do scripts, it is just that I do not want to be scripting all everyday tasks I have to do. I administer and develop on hundreds of NAV databases, so what I need is a fast and easy access to the most important administering tasks. One of those things is backing up and restoring company data in the native fbk format. At the moment I am still at shock on the fact that this is no longer possible.

    We have many ongoing cases where the implementation has been started with NAV2013 (with no rollups, since there are none for Finland) and decided we will upgrade them on the fly when 2013R2 is released. I had planned to do this by creating a new 2013R2 database, adding the modifications to objects and then restoring the data. Well, now I have to think again.

    I wonder if this can be done by opening the 2013 database with 2013R2 client and then importing all R2 objects and then recreating the mods? Will the masterdata structure be so alike that the existing data will suit the R2?
  • vremeni4vremeni4 Member Posts: 323
    In a way I like PowerShell, but I see it as a "backup" tool, tool to be used by technical people to create scripts to speed up some processes if needed.
    The problem is that NAV Customers create, delete, rename or move companies on everyday basis.

    In the future they will be able only to do this via PowerShell.
    For Example: this is script to copy a company in a tenant environment 
    Mount-NAVtenant -ServerInstance dynamicsnav71 -ID Default -Databasename "Demo Database NAV (7-1)" -OverwriteTenantIdInDatabase
Dismount-NAVTenant -serverinstance dynamicsnav71 -tenant LIVETenant
HowTo-MoveCompanyToTenant dynamicsnav71 -FromDatabase "Demo Database NAV (7-1)" -OldTenantName 'Default' -newTenantName 'LIVETenant' -RemoveCompanWhenMove
    How is e.g. an accountant with some basic IT skills supposed to understand and run this ?
    Even some IT guys would be scared to run this.

    I think this version of NAV 2013 R2 will end up as Windows 8 and "Start" button.
  • davmac1davmac1 Member Posts: 1,283
    In SQL Server Management Studio allows you to do most activities using the GUI. Some options are only available through command language - T SQL, Powershell, etc.
    NAV should take the cue from this proven methodology. Make most things available through GUI and also use PowerShell.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • mdPartnerNLmdPartnerNL Member Posts: 802
    Don't expect this to be solved quickly.

    Did anyone see with SQL profiler what the old backup/restore program did? I know it's mad but hey I need this for upgrades and looking back in earlier fbk backups made..
  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Small update; Microsoft is looking at the issue and might introduce an alternative

    http://markbrummel.wordpress.com/2013/1 ... -stewards/
    Marije Brummel | Freelance Business Central Specialist
  • davmac1davmac1 Member Posts: 1,283
    We can only hope.
    I use it all the time at customer sites and on my development systems.
    Doing things this way frees up my time since there are only 2 or 3 things to do.
    Backup company or companies
    restore companies
    optionally rename the company if is a test database at the customer so they don't enter live data by accident into a test database.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • vremeni4vremeni4 Member Posts: 323
    A small SQL script is available that can be used to Copy company from one database into another.

    http://www.mibuso.com/forum/viewtopic.php?f=32&t=59261&p=283960#p283960
Sign In or Register to comment.