Lansweeper data, reports and settings are stored in a database. Your database is hosted in either the Microsoft SQL LocalDB, Microsoft SQL Server or (deprecated) Microsoft SQL Compact database server. Though Lansweeper has a built-in report builder and a built-in tool for running database scripts, you may at some point want to connect to your database using an external tool. To connect to SQL LocalDB and SQL Server databases, Microsoft's SQL Server Management Studio can be used. To connect to a SQL Compact database, SQL Compact Toolbox can be used.
Microsoft Visual Studio Express 2008 SP1 can create, modify, and query CE 3.5 SP1 database files. SQL Server Management Studio cannot read CE 4.0 files. Visual Studio 2010 SP1 can handle CE 4.0 database files. citation needed The.sdf ('Sqlce Database File') naming convention is optional, and any extension can be used. citation needed. SQLite & SQL Server Compact Toolbox. My tools and utilities for embedded database development. Visual Studio & SSMS 17.x extension, standalone app and command line tools, for managing all aspects of your SQL Server Compact/SQLite database files' data and schema, including generation of code, database diagrams and database documentation. I'm using Visual Studio Community 2017 with below version: The last thing that I do to the installer was modifying the Visual Studio to have.NET framework until 4.7.2 SDK. And the toolbox is suddenly missing from Tools submenu. But the SQL Server CE Toolbox is there in 'Extension and Updates': I also download the SQL Server CE Toolbox VSIX.
This article explains how to view the raw data in your SQL Compact database using SQL Compact Toolbox. If you are unsure which database server you are using, you can verify using the ConfigEditor tool or in the Lansweeper web console.
• Reports can be run in the Lansweeper web console under ReportsCreate New Report.
• Scripts can be run in the following tool on your Lansweeper server, though you should generally only run scripts if requested by the Lansweeper support team: Program Files (x86)LansweeperToolsDatabaseMaintenance.exe.
To connect to a SQL Compact database using SQL Compact Toolbox, do the following:
- Download SQL Compact 4.0 SP1 throughthis download linkand install it on your Lansweeper server.Don't skip this step! SQL Compact must be installed as a separate software on your Lansweeper server in order to connect to your database with the SQL Compact Toolbox later on.
- Download the Standalone 4.0 daily build of SQL Compact Toolbox throughthis download link and unzip the file.SQL Compact Toolbox is a third-party tool. The Lansweeper support team cannot troubleshoot potential issues with this tool.
- Run the Toolbox executable as an administrator on your Lansweeper server.
- Right-click No SQL Server Compact Data Connections found and choose Add SQL Server Compact 4.0 Connection...
- Hit the Browse... button in the resulting popup and select your Lansweeper database file. The default path of the file is:Program Files (x86)LansweeperSQLDatalansweeperdb.sdf
- Hit the Close button at the bottom of the popup window.
- Expand the Lansweeper database so you can view and query database tables.Do not make changes to data unless you have a deep understanding of the Lansweeper database structure and SQL in general! Manual data changes are likely to break your Lansweeper installation. If you do decide to make changes or run a script, back up your database first.
In this blog post, we will look into a useful must-have Visual Studio 2019 extensions for database projects that help you in building database related queries and ORM related development with great ease.
Visual Studio is one of the best developer friendly Integrated Development Environment (IDE). The IDE has tons of features that help to ease the development process. These features can be further customized or new features can be added using Visual Studio Extensions. These extensions are available at Visual Studio Marketplace. Here is the list of top 5 extensions that will be discussed in the blog post.
List of Visual Studio 2019 Extensions for Database projects
- SQL Search by Redgate
- Entity Framework Visual Editor
- SQLite/SQL Server Compact Toolbox
- LINQ Insight Express ORM Profiler
- LINQ Insight Express ORM Profiler
A brief discussion of these extensions
SQL Search by Redgate: The extension help you quickly search and navigate across multiple SQL Server database objects. The features provided by the extensions are, quickly find fragments in SQL tables, views, stored procedures, functions, views, scheduled jobs. The user can search using wildcards and booleans and can find references to an object. The same extension can also be used in SQL Server Management Studio as well. The extension has been downloaded more than 135K.
Entity Framework Visual Editor: The is one of my favorites extension, it allows to see the visual design of the entities (persistent classes) along with the fast and easy way to add new model files. The entities hierarchy and cardinalities like Inheritence, one to many, many to many are cleanly depicted in the visual editor. A few of the other good features of this extension are the abilities to import entities from existing C# source, compiled DbContext from EF6 and EFCore assemblies, generate output from T4 templates. Classes and enumeration are displayed in different color schemes to visually group the model and many others. The extension also has a great step by step documentation to get the most from the editor.
SQLite/SQL Server Compact Toolbox: If you use embedded databases like SQLite or SQL Server compact edition for development purposes then this extension will really stand out for you. The extension provides a very convenient to script tables and data, helps in migrating from SQLite or SQL Server Compact to SQL Server (LocalDB/Express) or SQL Server or SQL Azure via script. The extension can be used to explore all the database objects, SQL queries can be executed from within the editor, it supports syntax coloring and has built-in support for displaying query estimates and actual plans. The extension can also be used to generate LINQ to SQL classes and much more.
EntityFramework Reverse POCO Generator: This is another great extension that has been downloaded and installed more than 424K times. The extension allows a developer to reverse engineer an existing database and generate POCO (Plain Old C# Class) classes, configuration mappings, and the DBContext class. At the time of writing SQL Server, SQL Server Compact 3.5 and 4.0 are supported.
LINQ Insight Express ORM Profiler: The extension provides very useful features for LINQ and ORM development. It provides design-time LINQ query execution and supports preview of generated SQL statements. It can help in profiling data access events for ORMs like Entity Framework, NHibernate, LinqConnect and LINQ to SQL mappings. Few of the benefits provided by the extension are, it fully integrates with Visual Studio and you can view SQL to LINQ queries with leaving the IDE, you can perform Query Analysis, it detects changes in the database context and queries and even provides variable value replacement and the best of all you can preview generated SQL at design time.
This concludes the post about my list of top must-have Visual Studio 2019 extensions for database projects, I hope you found this post helpful, thanks for visiting, Cheers!!!
If you want to explore all the available Visual Studio 2019 extensions for databases, you can visit the Visual Studio Marketplace here: https://marketplace.visualstudio.com/
[Further readings: Visual Studio 2019 Output Window | How to navigate code in Visual Studio 2019 | How to change Visual Studio 2019 Theme | Top 7 must have Visual Studio 2019 extensions]