All geek questions in one place

How to write and run update script for .sdf databases?

How to write and run update script for .sdf databases? Can sqlcmd do this? I am not trying to update the version of the database file. I am trying to update a schema and the data inside it.

+3
source share
2 answers

Rewritten

You can use SQL Compact TSQL commands such as ALTER TABLE and UPDATE .

This can be done using your client choice, whether inside the application, using the SqlServerCe methods (you will need to consult the SQL Compact library) or using a client such as SQL Server Management Studio.

Just remember that SQL Compact only allows one process to connect to the database at a time.

0
source

You can run the script in the SQL CE database manually as follows:

  • Open Microsoft SQL Server Management Studio
  • Click New Query on the toolbar. The Connect to Server dialog box appears.
  • Set Server Type to "SQL Server Compact Edition"
  • .sdf

, . .

0

Source: https://habr.com/ru/post/1762359/

More articles:


All Articles