Works for me.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 11 May 2011 11:26, Dave Watts dwa...@figleaf.com wrote:
You could always both swap to a real database:
http://www.oracle.com/technetwork/database/express-edition/overview/index.html
Your DB2 link is
No. Not all DB's are equal just because they all run SQL.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 11 May 2011 10:45, Maureen mamamaur...@gmail.com wrote:
They are all real databases. The majority of the problems that
website databases have are caused by
Funnily enough I looked into Oracle Express recently for a client, and it is
not actually suitable for web apps. It is primarily intended for mobile
platforms or portable media.
On Wed, May 11, 2011 at 8:58 AM, James Holmes james.hol...@gmail.comwrote:
No. Not all DB's are equal just because
Will, I pinched some of Gerald's popcorn and had a good read, thanks for all
the replies. It has been very interesting reading the discussion on the
various DB's.
Overall, SQL Server Express is coming out on top for me. My existing
databases don't get anywhere near the 10GB limit, and I
Here is a complete feature matrix.
http://msdn.microsoft.com/en-us/library/cc645993.aspx
I'm sure I used SSIS with 2005 Express, so I would expect it is with 2008.
You certainly have import/export services anyway.
Just make sure you get SQL Server Express with Tools.
If you find features missing
lol. ;-)
On 5/10/2011 8:26 PM, Dave Watts wrote:
You could always both swap to a real database:
http://www.oracle.com/technetwork/database/express-edition/overview/index.html
Your DB2 link is broken.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
I second the comment on Navicat. It's intuitive and easy to use and the new
Premium edition supports MS-SQL as well as MySQL, Postgre, Oracle and SQLite.
And no, I don't have any affiliation with them, I just love their product :-)
I've converted several databases from MS-SQL to MySQL with no
While installing the trial of SQL Server 2008 will get you the full
Management Studio and Business Development Studio (or whatever it is
called in 2008, and is required for developing SSIS solutions), SQL
Server Express does not have the SSIS service. You have to have at
least one full SQL
FWIW, here's some code for automating the backup process in SQL Server
Express:
http://www.cfgears.com/index.cfm/2010/7/20/Automating-backups-for-SQL-Server-Express
Thanks,
Eric Cobb
http://www.cfgears.com
Help me make a difference this summer -http://bit.ly/i8dJvQ
On 5/11/2011 1:36 PM, Carl
: Re: Migrating a DB from MS SQL 2000 into MySQL latest release
I second the comment on Navicat. It's intuitive and easy to use
and the new Premium edition supports MS-SQL as well as MySQL,
Postgre, Oracle and SQLite. And no, I don't have any affiliation
with them, I just love their product
Judah,
Yes it is nice to have power, but it is rather like buying a Porshe to drive
around town at 30MPH, sure you can brag about it and tell everyone how you
could drive at 200mph if you wanted to, but really you are never going to do
it, and a more practical car is really going to do a better
.
I've had good experience with it and highly recommend it.
Rick
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Tuesday, May 10, 2011 7:14 AM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release
Judah,
Yes it is nice to have
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release
Judah,
Yes it is nice to have power, but it is rather like buying a Porshe to
drive
around town at 30MPH, sure you can brag about it and tell everyone how you
could drive at 200mph if you wanted to, but really you are never
Or like this:
http://www.google.com.au/search?sourceid=chromeie=UTF-8q=ms+sql+express+corrupt+tables
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 10 May 2011 22:31, Russ Michaels r...@michaels.me.uk wrote:
The common problems and issues can be googled, like this
Yes James, well done :-)
On Tue, May 10, 2011 at 3:37 PM, James Holmes james.hol...@gmail.comwrote:
Or like this:
http://www.google.com.au/search?sourceid=chromeie=UTF-8q=ms+sql+express+corrupt+tables
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 10 May
-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Tuesday, May 10, 2011 10:31 AM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release
I'm glad your experiences have been good Rich. Perhaps you can quantify the
scale, i.e how many
[mailto:r...@michaels.me.uk]
Sent: Tuesday, May 10, 2011 10:31 AM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release
I'm glad your experiences have been good Rich. Perhaps you can quantify the
scale, i.e how many databases over how long, i'm sure
Michaels [mailto:r...@michaels.me.uk]
Sent: Tuesday, May 10, 2011 10:31 AM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release
I'm glad your experiences have been good Rich. Perhaps you can quantify
the
scale, i.e how many databases over how long, i'm sure
Re: good code:
I've done this once (and am about to do it again) so I'll share a few
bits that I learned re: code changes:
99% of my code was fine. But I had to adjust some syntax.
MSSQL vs MySQL:
LEN needs to be LENGTH
CHARINDEX needs to be LOCATE
There probably are more differences like
It honestly wasn't my intention to start any sort of flame war. I
truthfully did find the comment humorous.
It was like stating that this 2oz kitten is more powerful then this
T-Rex over here. I had to laugh.
Maybe the kitten has super-robot ninja powers?
Honestly, it sounds to me like
lol, of course not :-)
We will have to agree to disagree.
I will stick with my super ninja bionic kitten, you stick with your
extinct Jurassic fossil :-)
On Wed, May 11, 2011 at 1:10 AM, Jordan Michaels jor...@viviotech.netwrote:
It honestly wasn't my intention to start any sort of flame
You could always both swap to a real database:
http://www.oracle.com/technetwork/database/express-edition/overview/index.html
:-O
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 11 May 2011 08:51, Russ Michaels r...@michaels.me.uk wrote:
lol, of course not :-)
We
They are all real databases. The majority of the problems that
website databases have are caused by badly written code, inefficient
queries and poor performance tuning, and have nothing to do with the
database platform.
On Tue, May 10, 2011 at 6:24 PM, James Holmes james.hol...@gmail.com
You could always both swap to a real database:
http://www.oracle.com/technetwork/database/express-edition/overview/index.html
Your DB2 link is broken.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business
don't forget that MSSQL express is also free and more powerful than mysql
community edition so there is no need to migrate to MySQL unless your also
moving to Linux.
There are however free migration tools on the mysql site that will do it for
you.
On Mon, May 9, 2011 at 11:29 PM, Jenny
I find the more powerful comment humorous.
SQL Express limits are here:
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
Migration from MS SQL to MySQL documentation is here:
http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html
Russ Michaels wrote:
don't forget that MSSQL express is also free and more powerful than mysql
Jordan Michaels jor...@viviotech.net wrote:
I find the more powerful comment humorous.
This should be fun to watch :) I am making some popcorn. Anyone want some?
G!
On Mon, May 9, 2011 at
Perhaps you tried to run MSSQL on linux Jordan, that would certainly
be humorous I imagine :-)
On Tue, May 10, 2011 at 12:12 AM, Gerald Guido gerald.gu...@gmail.comwrote:
Russ Michaels wrote:
don't forget that MSSQL express is also free and more powerful than mysql
Jordan Michaels
Well, it is pretty damn funny.
I've migrated from MS SQL to MySql before and it generally isn't too
bad. There are various migration tools available, I like the ones from
Red Gate. MySql has some funkiness that comes into play if you want to
combine foreign keys and full text indexing from what
Or possibly Jordan has needed a database that runs on more than 1 CPU,
uses more than 1GB of RAM or has a db size of more than 10GB :)
On Mon, May 9, 2011 at 4:20 PM, Russ Michaels r...@michaels.me.uk wrote:
Perhaps you tried to run MSSQL on linux Jordan, that would certainly
be humorous I
Many people often wrongly assume that MySQL is simply FREE, which is not
correct. Many people are also completely unaware that there is a FREE MSSQL
Express edition.
The FREE version is the community edition, which also has limitations, look
them up, If you want enterprise features then you have
MySql is free though licensing is a bit complicated because of a
dual-license model. The community edition includes many enterprise
sorts of features like replication and partitioning. If I recall,
there are additional backup tools and monitoring in the paid
enterprise edition. If you want to go
32 matches
Mail list logo