2
I have a local bank on my desktop, in it I developed an application using C# and Asp.Net MVC and thought it would only take the trouble to migrate to some MS SQL database when uploading the project.
However, I need to transfer the data from this local database to my notebook to perform the presentation of my application.
The question: How is a local bank stored? Is a passive file generated for the transfer? The authentication method turns out to be windows authentication?
4
If you have SQL Server installed on the laptop, the ideal is for you to take a backup of the database on the development machine, and recover it on the laptop. It is the recommended procedure and avoids errors related to references that SQL can maintain internally to base objects.
In DBA language, you will make a Detach in the dev machine and a Attach on the laptop. The instructions, in detail, are in the links below the MSDN, separated by version:
As for authentication, it is the one you have set up. If it is authentication via SQL and does not remember the SA password, open a question about how to reset it, ok?
Browser other questions tagged c# asp.net-mvc database
You are not signed in. Login or sign up in order to post.
It depends on how you set up the local bank. Authentication is the one you have set up for it. As for the files, what do you mean by "liability to transfer"?
– Oralista de Sistemas
I get it. I meant some file which I can find on disk and transfer to another computer on which it is possible to import and/or reference that local database.
– Rafael Barbosa