I've got an application that deploys to a large number of users desktops. The application install path includes an App Data folder where I store the LocalDB.mdf file. All works well.
I've got a couple of cases where the IT departments of the clients wants to place my application on a server so users can remote into using RDP to run my application. When more than one user attempts to use the application user instance will not work
because more than one user can't have a connection to the LocalDB.mdf in my applications App Data folder.
I'd like to have the LocalDB.mdf deploy to the Users\AppData\Local\Microsoft\Microsoft SQL Server Data\ folder, but I'd think that would be a management nightmare if I had to make a physical change to the structure of LocalDB.mdf and deploy it with an update.
I know that when a user instance fires up it copy's master and msdb from the Template Data folder. Is there a way to deploy my LocalDB.mdf just lik ...
Go to the complete details ...