SQL Server Compact 3.5 64bit coming soon in Sp1...

re: SQL Server Compact 3.5 64bit coming soon in Sp1...

ErikEJ — Thu, 09 Oct 2008 15:27:29 GMT

What I meant to say was: Are there any news about the Data Migration Wizard or similar solutions?

re: SQL Server Compact 3.5 64bit coming soon in Sp1...

ErikEJ — Thu, 09 Oct 2008 15:25:13 GMT

Hi Steve,

many SQL Compact users have trouble understanding the need to buy third party tools in order to migrate data from SQL Compact and SQL Server and vice versa.

re: SQL Server Compact 3.5 64bit coming soon in Sp1...

Ram — Fri, 16 May 2008 00:53:08 GMT

Thanks! I used the sync designer and worked fine - for now this is good enough.

I have stored 25,000 so far, but yet to modify my app to work with CE db. Though CE supports image data type will one face any performance issues storing say 50,000 images @ 30KB/file.

Thanks,

Ram

re: SQL Server Compact 3.5 64bit coming soon in Sp1...

Steve Lasker -MS — Wed, 14 May 2008 07:16:20 GMT

Hi Ram,

As much as I’d like to send this out, it’s just not practical as we just have too many lose ends we haven’t cleaned up. However, here’s what I’ve been doing.

If you use the Sync Designer in VS 2008, you can set the “data to download” to “entire table each time”. This will simplify the tracking columns required on the server and you’ll just get your data. Better yet, you can “synchronize it” when you want. Sync Services will automatically create the schema required within SQL Server Compact, so you should be “good to go”.

As soon as we can get the Data Migration Wizard out, we will. …even if it’s pre-release. But it’s just too preeee at this point.

Steve

re: SQL Server Compact 3.5 64bit coming soon in Sp1...

Ram — Wed, 14 May 2008 03:00:26 GMT

Steve,

I understand the tool is not yet tested, but would it be possible to get hands on with it. I am in the process of desiging a new application (poc initially) for my client with VS2008/SQL2008/SQLCE and just creating sample databases is a real pain.

Thanks.

Ram

re: SQL Server Compact 3.5 64bit coming soon in Sp1...

Steve Lasker -MS — Wed, 14 May 2008 02:53:42 GMT

Yeah, it is definitely a frustration point for our customers and us. We've actually had a “Data Migration Wizard” near ready since we shipped SQL Server Compact 3.1. But it always seems to fall low on the priority list, so it still hasn’t received the QA pass we need to ship it. Things like Platform Builder and 64bit support were higher in the list, but even those got delayed 

So, at this point, we know we can’t get it “in” SP1, but we hope to ship it just after SP1 when the QA team has a moment to breath. We may also ship a sample to help customers in the meantime, but we hear the pain and I hope we’ll have something out by the end of this summer…

In the meantime, JP at Prime Works have got some great tools that do help in the meantime.

Steve

re: SQL Server Compact 3.5 64bit coming soon in Sp1...

Ram — Wed, 14 May 2008 01:33:08 GMT

Hi Steve,

Will there be a simple tool (not replication) for SQLCE in SP1 that will allow someone to populate a CE database from SQL Server so that demo databases can be built faster.

I think this is something that is lacking in SQLCE for a while.

Thanks,

Ram

re: SQL Server Compact 3.5 64bit coming soon in Sp1...

Steve Lasker -MS — Wed, 14 May 2008 00:51:38 GMT

Yes, we did release the beta of the SP, including Compact, but we didn't include the 64bit release in this beta.

Steve

re: SQL Server Compact 3.5 64bit coming soon in Sp1...

Leon — Tue, 13 May 2008 23:07:09 GMT

Hey Steve...

If I am not mistaken, wasn't there a Visual Studio 2008 SP1 and SQL Server 2008 beta release yesterday or today..

does this release contain 64bit implementation?

thanks