Managing SSCE v3.5 thru VS2008 and/or SSMS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlos - 15 Feb 2008 20:00 GMT

Hi all,

I just found out that if I want to edit the schema for a table within
VS 2008 I can't. (for instance change the 'Allow Nulls' property in a field
from 'No' to 'Yes').

I tried it using SSME but the tool apparently does choke when it finds
that the table has a different format. Even though I select the server type
to
be 'SQL Server Compact Edition'.

I thought that at least the feature to edit the schema could be done from
within VS 2008..!

Does anyone know how to do these tricks?

Thanks,

Carlos.

Reply to this Message

Ginny Caughey [MVP] - 15 Feb 2008 20:41 GMT

Carlos,

You should be able to change the table schema of a SSCE 3.5 database using
Visual Studio 2008. Open the Server Explorer and expand the Data Connections
node. Select your SSCE 3.5 database file. Expand the node until you see
Tables, then expand that node until you find the table you want to change.
You should be able to right-click on the table name and select Edit Table
Schema.

SSCE 3.5 databases are not support by SQL Server 2005 Management Studio as
you found, but they are supported with SQL Server 2008 Management Studio.

Signature

Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Scalehouse and Billing Software for Waste Management

> Hi all,
>
[quoted text clipped - 16 lines]
>
> Carlos.

Reply to this Message

Carlos - 21 Feb 2008 13:51 GMT

Ginny,

Thanks again!

Carlos.

> Carlos,
>
[quoted text clipped - 28 lines]
>>
>> Carlos.

Reply to this Message