O'Reilly logo

Microsoft SQL Server 2005, Compact Edition by Trent Swanson, Prashant Dhingra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Getting to Know the Tools

IN THIS CHAPTER

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. To allow rapid application development, Microsoft has added tight integration between SQL Server Compact Edition 3.x, SQL Server 2005, and Visual Studio 2005.

Using SQL Server Management Studio, developers and administrators can manage the SQL Server Compact Edition database located on a device or on a desktop. You can design tables, columns, constraints, and indexes using SQL Server Management Studio.

Similarly ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required