Steve Lasker's Web Log

Hi Sameer,

Your correct that VS doesn't have the nice, generic T-SQL editor like SQL Server Management studio.  This is something we're hoping to consolidate in the next release of Visual Studio.  While you can do this in Management Studio 2008 (CTP5), you can also do this in code with VS 2008.

In this sample Creating Database Schema In Code you'll see how I saved the database schema creation scripts as a embedded, strongly typed resource.  You could author your Identity Inserts here when used within your application.

If you're looking for a generic T-SQL editor to poke around during development, than Management Studio 2008 is what you'll need today.

Steve

Hi Peter,

There are actually two questions.  

Q: Does Compact work against FX 2.0, or does it require FX 3.5?

A: Other than the ADO.NET Entity provider comming in SP1, Compact 3.5 will work perfectly fine on FX 2.0.  As you may know, FX 3.5 is really "extensions" to 2.0, not a whole 'nother version.

Q: Will Compact work on Win 2k.  

A: Technically, Compact 3.5 does work on Win2k.  However, we no longer run our test suites on Win2k, so it's not officially supported.  FX 3.5 isn't supported, and possibly doesn't even work on Win2k, so we decided to stop running our test suites on Win2k as QA is often the biggest constraint a product team has to move forward.

Steve

Hi Scott,

If I understand the question, you've started your app with Compact, including the Schema and Data.  You now want to create that Schema and Data in SQL Server (Express through Enterprise).

Sync Services, RDA, and Even Merge Replication all assume the database and schema were created on the server first, and you then synchronize the schema and data down to Compact.

We do have an Upsizing wizard internally that we've been hoping to release publically.  Let me check to see if it’s in a form to make public in a CTP like fashion.

To get you going in the meantime, Sync Services was designed to handle this situation.  The trouble you're having with scripting out the tables on the server, than synchronizing them is the default options of SyncTable on the SyncAgent configuration don’t attempt to preserve the local data.

Simply set the SyncTable you’re looking to maintain to be SyncTable. TableCreationOptions  = TableCreationOptions.UploadExistingOrCreateNewTable

Here’s a post that should be able to help you out:

http://forums.microsoft.com/sync/ShowPost.aspx?PostID=1200923&SiteID=75

Steve

Hi,

Yes, you can open connections from multiple threads and processes on the same machine, and this is fully supported.  We use shared memory to map connections between multiple processes.

The thing we stop at is supporting multiple connections from remote machines.  We really don’t want to re-create the Jet problem where people can get a few connections to a network share, and then things just start getting ugly.  As files continue to grow, it’s just not practical to manage a data file across the network.  You could of course, write a service to front Compact so you get true client/server behavior, but Compact isn’t tuned for thrashing of hundreds of concurrent connections.  If you need multiple connections from the network, this is really where Express is a great place to start.

However, for your initial question, yes, this is fully supported.

Steve

Hi Lee,

Yes, we absolutely do have a 64bit release coming.  With the popularity of private deployment, we had a few extra challenges we wanted to get right before releasing it, so it’s coming in our SP1 release.  I’ll be posting more info when I have dates I can tell customers when they can get a download of a beta.

Steve

Hi Leon,

The SP1 Beta of Visual Studio 2008 and SQL Server Compact is available here.  When you install Visual Studio SP1, you�ll get Compact SP1 as well.  However, this unfortunately doesn�t include the beta of our 64bit release.  Since this didn�t ship �in VS 2008�, it doesn�t get included with the SP.

The official statement for SP1 release is �this summer�, which is when we�ll be releasing the 64bit bit release as well.  If you�d like to contact me directly, we can see if we can help you in the shorter term if this doesn�t meet your schedule needs.