Geeks With Blogs
A Curious Mind #tastic

This whole SQL Mobile er SQL Everywhere stuff does not make me a happy camper. Because of this name change we are suffering from name pollution. This has a larger effect on me as I am just starting to use SQL Everywhere for a project and I am struggling to find any good information on any of my questions. grrrr.... I am all for better names but this one hit me in a bad way.

Also, what in the hell am I missing that I can't export data into my SQLE data base from my full blown DB? This is a choice killer for me. I know nothing about replication and have no desire to, yet I am required to, in order to get data into SQLE. To hell with that I will just use VistaDB, it has a Migration Wizard (so much easier). So MSFT I would rather use your product, so lets make that happen!

Feature Needed for SQL Everywhere:
  • Import Data
  • Export Data
  • Tight Integration with SQL Server Management Studio
Posted on Wednesday, June 28, 2006 12:20 PM | Back to top


Comments on this post: SQL Everywhere

# re: SQL Everywhere
Requesting Gravatar...
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
Left by D'Arcy from Winnipeg on Jun 28, 2006 1:04 PM

# re: SQL Everywhere
Requesting Gravatar...
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.
Left by Dru on Jun 28, 2006 2:41 PM

# re: SQL Everywhere
Requesting Gravatar...
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!
Left by Sarah Blow on Jul 28, 2006 3:58 PM

# re: SQL Everywhere
Requesting Gravatar...
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
Left by phoenix on Sep 04, 2006 11:18 AM

# re: SQL Everywhere
Requesting Gravatar...
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
Left by Steve Lasker on Sep 16, 2006 3:30 AM

# re: SQL Everywhere
Requesting Gravatar...
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
Left by Rajesh on Jan 09, 2008 11:11 AM

# re: SQL Everywhere
Requesting Gravatar...
Rajesh, not quite sure what you are trying to say here.
Left by Dru on Jan 09, 2008 6:19 PM

Your comment:
 (will show your gravatar)


Copyright © Dru Sellers | Powered by: GeeksWithBlogs.net