Manage ssce 3.5

I have been having "fun" trying to get all the bits (SSCE 3.5, Orcas Beta 2, SQL Managment Studio) in Vista 64 and Xp 32.

So far I have found at the SQLMetal does work with SSCE 3.5 but not in Vista64

BUT I cannot get any tool (tried SQL and SLQ express) to manage my SSCE db - ie make relationshipos so that SQLMatal can do its stuff

Any advice as to which tool to use to manage SSCE 3.5

Thanks

Mike

From Data Connections in VS 2008 beta 2, you can manage SQL Compact 3.5 databases, tables, indexes and even relations (new feature).

You can also manage relations with SQL script, like this:

ALTER TABLE ADD CONSTRAINT ...

Integration between SQL Compact 3.5 and SSMS 2008 July CTP is not yet availabel, as noted in the SQL Server 2008 July CTP readme.

|||

Thanks - did not know about SSMS CTP

Have managed to get the SQL script to work but cannot see anywhere is VS 2008 Beta 2 to manage relationships or index - I have been through all the possible menu items so I could do with a pointer to the correct place

Thanks again

Mike

|||

Open Visual Studio 2008. Select View, Server Explorer from the menu. Create a connection to an existing or new SQL Compact 3.5 database. Open the database, select the Tables node, right click a table (or create one).

Relations: Select Table Properties, and then you can choose the Add Relations page.

Indexes: Expand the table name node, and right click indexes, then you have the Create Index menu option, which will take you to the New Index dialog.

Hope this helps!

|||

Hi

Many thanks - found it !!

Mike

sql