OT? VistaDB...anyone use it? Thoughts?

[darrel]

I've been playing with Grafitti CMS and noticed that they use the 'vistadb'
format by default. I had never heard of it before.

http://www.vistadb.net/

I'm intrigued. It looks like a full SQL DB, without the overhead of MS SQL
at the server level. Ie, it's 'just a file' that you can move as needed.

I recently worked on a project with someone that's used to MySQL land. They
were surprised that moving the MS SQL Db wasn't a simple manner of
drag-n-drop. Seems that that would be the main advantage of VistaDB.

Anyone use this for their own web apps? What do you think? Pros? Cons?

-Darrel

[Leon Mayne]

Re: OT? VistaDB...anyon e use it? Thoughts?

"darrel" <notreal@nowher e.comwrote in message
news:OC4ZM9ZaIH A.4808@TK2MSFTN GP05.phx.gbl...

I've been playing with Grafitti CMS and noticed that they use the
'vistadb' format by default. I had never heard of it before.
>

http://www.vistadb.net/

>
I'm intrigued. It looks like a full SQL DB, without the overhead of MS SQL
at the server level. Ie, it's 'just a file' that you can move as needed.
>
I recently worked on a project with someone that's used to MySQL land.
They were surprised that moving the MS SQL Db wasn't a simple manner of
drag-n-drop. Seems that that would be the main advantage of VistaDB.
>
Anyone use this for their own web apps? What do you think? Pros? Cons?

Never seen it before. Personally I'd rather stick with SQL Express, and if I
didn't need stored procedures and wanted it to be single file based then I'd
use the compact edition (SQL Server Everywhere, or whatever it's called
now).

--
Leon Mayne

http://leon.mvps.org/

[darrel]

Re: OT? VistaDB...anyon e use it? Thoughts?

Never seen it before. Personally I'd rather stick with SQL Express, and if

I didn't need stored procedures and wanted it to be single file based then
I'd use the compact edition (SQL Server Everywhere, or whatever it's
called now).

I was actually excited about SQL Express in VS 2005, but it seemed to fail
at the implementation level...mainly it seemed that few web hosts bothered
to support it, as you still needed server-level software installed to run
it. VistaDB (what little I know of it) seems to me what SQL Express should
have been. ;o)

I'm not familiar with SQL Server Everywhere. I need to look into that option
too.

-Darrel

[Mark Rae [MVP]]

Re: OT? VistaDB...anyon e use it? Thoughts?

"Leon Mayne" <leon@rmvme.mvp s.orgwrote in message
news:52680762-7221-4C30-B513-00D7D2A0FBB5@mi crosoft.com...

Never seen it before. Personally I'd rather stick with SQL Express, and if
I didn't need stored procedures and wanted it to be single file based then
I'd use the compact edition (SQL Server Everywhere, or whatever it's
called now).

SQL Server Compact Edition...

Also, FYI: http://www.vistadb.net/compare_sql_compact.asp


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[Mark Rae [MVP]]

Re: OT? VistaDB...anyon e use it? Thoughts?

"darrel" <notreal@nowher e.comwrote in message
news:uIANdfaaIH A.4696@TK2MSFTN GP05.phx.gbl...

I'm not familiar with SQL Server Everywhere.

No longer exists: http://www.microsoft.com/sql/editions/default.mspx

http://www.microsoft.com/sql/editions/compact/default.mspx

--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[darrel]

Re: OT? VistaDB...anyon e use it? Thoughts?

SQL Server Compact Edition...

>
Also, FYI: http://www.vistadb.net/compare_sql_compact.asp

Ah! Nice. I'll look at that.

(I hope MS outgrows the 'every product needs 12 editions' phase soon... ;o)

-Darrel

[Mark Rae [MVP]]

Re: OT? VistaDB...anyon e use it? Thoughts?

"darrel" <notreal@nowher e.comwrote in message
news:OLWq77aaIH A.5976@TK2MSFTN GP05.phx.gbl...

>SQL Server Compact Edition...
>>
>Also, FYI: http://www.vistadb.net/compare_sql_compact.asp

>
Ah! Nice. I'll look at that.

I'm not sure whether it's been updated for SqlCe 3.5, though...


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[VistaDB]

Re: OT? VistaDB...anyon e use it? Thoughts?

I'm not sure whether it's been updated for SqlCe 3.5, though...

For the most part yes. Our compare page shows the differences between
3.1 (VS 2005 only) and 3.5 (VS 2008 only). 3.5 is a patch mostly,
still CPU limits, still no stored procs, missing datatypes, no ASP.NET
support (unless you force the override and MS tells you it is not
supported that way).

I still feel VistaDB is a great replacement for SQL CE for asp.net
developers. We allow shared hosting support (partial trust / medium
trust) and we have true XCopy deployment. Of course I could be a
little biased since it is my product. :)

Jason