![]() ![]() ![]() SQL Server Management Studio is installed on your computer along with the SQL Server 2005 installation. Using SQL Server Management Studio, you can manage SQL Server 2005 database, SQL Server Compact Edition 3.x database, Integration Services, Analysis Services, and Reporting Services. SQL Server Management Studio provides an integrated environment to manage the SQL Server family of databases. You will also learn how to set up a connection with the SQL Server Compact Edition database and finally how to deploy the application on platforms. You will become familiar with the Visual Studio interface and will learn how to include SQL Server Compact Edition in your project. You will also learn how to use SQL Server Management Studio and Query Analyzer to manage and manipulate the SQL Server database. In this chapter you will be familiarized with the available tools. Visual Studio also helps you to deploy a database on a device. Similarly you can use Visual Studio features to create, design, and manipulate the SQL Server Compact Edition database. You can design tables, columns, constraints, and indexes using SQL Server Management Studio. Using SQL Server Management Studio, developers and administrators can manage the SQL Server Compact Edition database located on a device or on a desktop. To allow rapid application development, Microsoft has added tight integration between SQL Server Compact Edition 3.x, SQL Server 2005, and Visual Studio 2005. One main limitation of the SQL CE 2.0 database released in 2002 was the need to manage the database either using a query analyzer tool on mobile devices or by running a program to manipulate data on a device. Microsoft SQL Server 2005 Compact Edition ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |