SQL Everywhere

# re: SQL Everywhere

Hey Dru,

There might not be much in the way of documentation for SQLE, but there is a lot for SQL Mobile. The only diff is that they've removed the requirement that the database be run on a mobile device, so all the articles for SQL Mobile will apply.

I can't really comment on the import/export, as the last project I worked on where we were sending data from sql 2005 to a sql mobile database, we weren't able to use replication because of network constraints (Apache, Novell, etc.). We ended up just sending a dataset down through a web service and massaging the data in that way.

However, you can connect to the mobile DB through SQL Management Studio 2005. There should be an option to connect to the mobile database file, and that will open it in the same way as a tradition SQL database...although still somewhat limited in what it can do (I recall some weird thing that you couldn't open the table to see the data unless you did a query...).

I'm planning on writing up an article for working with SQL-E, as I'm curious about how it fits in to design decisions as well. I'll keep you posted.

D
6/28/2006 1:04 PM | D'Arcy from Winnipeg

# re: SQL Everywhere

Yeah, even though I am aware of that and it does help, I can't help but feel like this is not a 1st class product for MSFT. I love that they release it for free and all the support but it just doesn't feel up to snuff.
6/28/2006 2:41 PM | Dru

# re: SQL Everywhere

I have to say from what I have played with on SQL Everywhere I am disappointed. I would have expected at the very least the latest version to link in with the Visual Studio IDE. Unfortunately it doesnt and you have to go back to using the SQL Mobile Version for that... It's really not ready yet! There are quite a few quirks with it and it needs a lot more work done still.

I have been playing with the mobile db stuff for a while and your right, in order to get data out to the mobile devices you do need to have a good understanding of replication and how to do the server side stuff. It's not exactly the simplest thing for people to get their heads round and some of the stuff just isn't user friendly like copying the dll file into the share folder for remote access calls etc.

Anyway Maybe we will be lucky and they will listen to us one day!
7/28/2006 3:58 PM | Sarah Blow

# re: SQL Everywhere

To link in with VS2005 then add a refernce to the project, then add the .sdf file to the project. You can then see everything in the server explorer - an added bonus is that VS2005 adds typed datasets for all the tables in the .sdf file.

The connection string is added into app.config 9/4/2006 11:18 AM | phoenix

# re: SQL Everywhere

When we ship VS2005 SP1 the tooling names will be updated from SQL Mobile to SQL Server Everywhere Edition. Honestly, we didn't think developers would really care what the product name was, and just wanted a fully supported Microsoft product, which SSEv surely is. SSEv will be a significant investment for us and we didn't want to wait 'till Orcas to get it out.
We are also looking at the best way to support import/export. We have some limited support in SQL Server Management Studio vis Integration Services, but we really want a tool within VS. There are some tools out there that developers have written. But we do know this is an issue and we're on it.
Yes, the docs need to be updated. We hoped to simply change the license restriction, tweak a few things and let it go. Marketing and management go so excited about the new Occasionally Connected Scenarios, and how they wanted to enable data everywhere, that they decided to change the name.
I hope you give SSEv a chance. It's a proven platform that has been a sleeping jem that we know plan to leverage in a big way.
Steve 9/16/2006 3:30 AM | Steve Lasker

# re: SQL Everywhere

Yes SQL Server 2005 CE is SQL Server Everywhere. Its a great achievement. Easy, User Friendly, Mobile, Light ... And bla bla

Use It Or U will Loose it 1/9/2008 11:11 AM | Rajesh

# re: SQL Everywhere

Rajesh, not quite sure what you are trying to say here. 1/9/2008 6:19 PM | Dru