I have a local database on my desktop, I made an application development using C# and Asp.Net MVC and I thought I would only have the job of migrating to some MS SQL database when I was uploading the project.
However, I need to transfer the data from this local bank to my notebook to show my application.
The question: How is a local bank stored? Is a passive file being transferred? Does the authentication method turn out to be windows authentication?
If you have SQL Server installed on your laptop, ideally you should make a backup of the database on the development machine, and recover it on the notebook. This is the recommended procedure and avoids references-related errors that SQL can keep internally to base objects.
In DBA language, you will make a Detach on the dev machine and an Attach on the laptop . The instructions, in the smallest details, are in the links below MSDN, separated by version:
As for authentication, it is the one you have configured. If it is authentication via SQL and does not remember the SA password, open a question about how to reset it, ok?
