How to install SQL Server database?

K

Konstantin2019-06-30 00:08:37

SQL Server

Konstantin, 2019-06-30 00:08:37

As I did before: I created a database in SSMS, then moved the database file to the folder with the program and connected to it and could transfer the program from one machine to another.
But what if I want the program, when transferred from one machine to another, to connect to its own database on its local server, because for this you need to manually upload this database to the server every time?
Can eat councils on interaction with a DB?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

K

Konstantin Tsvetkov, 2019-06-30
@nicebmw9

Installing SQL Server . Attach the detached mdf-file of your database to the program, which you attach on another machine. LocalDB can be used to simplify distribution of programs with local MS SQL .

D

d-stream, 2019-06-30
@d-stream

If you right-click on the database in SSMS and select script database as ... - you get quite such a "recipe" for creating the database structure and then filling it with data.