SQL Server Local Database development

Generate script in remote side database

Note the remote side of the database is the Chinese version of the English version, generally we are loaded in English version,

If the remote side of the database is the Chinese version, then our local is the English version, in the generated script that needs to be modified, while removing the corresponding road code.

Revision changed to

If we want to use the VS own DB as the local database, then we use

(LOCALDB) \MSSQLLOCALDB connection address

Disconnecting the network cable (terminating the connection to the remote end)

Then select the local database and execute the script

Connect the local database in VS

At this point, the local only has the database framework, the data is still not,

Using the VS Feature tool = "SQL Server new Database comparison

Disconnecting the network cable (terminating the connection to the remote end)

SQL Server Local Database development