sql database in ONEDRIVE

Business Central/NAV Technical Forum
1

I wish to use same NAV 2016 SQL SERVER databasee at home and at the office (just a test database).

How could I dettach database from standard data directory in sqlserver and attach it in a ONEDRIVE shared directory?

When I try to attach in sql server management studio, the dialog to choose the drive and directory dont show my onedrive directory.

2

You cannot do that. A SQL database must be on a “real” drive and will not show OneDrive directories or other network drives.

If you want to do this (for test only of course), then you also need to copy it to you C-drive at home.