Heya Andrew, We've been having so many problems with transferring data between SQL 2005 DBs that we are using this tool these days:
http://www.topshareware.com/SQL-Dumper-download-42374.htm SQL Dumper. It converts your whole database to a series of INSERT statements so you can easily recreate your data remotely. seeya -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Monday, 24 September 2007 9:52 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: MSSQL 2005 Developer Edition yes I do have a soft spot for MS SQL, but we are begining to use mySQL even more these days. Derby, I think it is still to young at the moment and needs to implement some very basic things like top and offset and a whole heap of other things. But will be keeping an eye on its progress that is for sure. As for the original question, MS haven't given to much thought to smaller situations like getting the DTS to work properly as I have had it fail so many times on the most basic things, and the fact that backing up a DB on a shared DB server is right pain in the arse. On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote: > > Indeed. I think it's a good product, but for commercial use I think MS SQL > or Oracle are pretty standard these days. > > While MySQL is getting better, MS SQL is also, MS SQL Express is now around > and I find myself using it for anything I need that's free, then when I want > to go main stream, i'ts off to MS SQL. > > I think you might find Andrew prefers MS SQL also, if he wasn't using it, he > wouldn't have the question. > > Mind you, I have a soft spot for Apache Derby. > > Regards > Dale Fraser > > http://learncf.com > > > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Andrew Scott > Sent: Monday, 24 September 2007 9:05 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition > > > Yes wars start this way :-) > > > On 9/24/07, Steve Onnis <[EMAIL PROTECTED]> wrote: > > > > You are playing with fire with a comment like that Dale. I am sure that a > > lot of people on this list and others would disagree with you saying that > > mySQL is a toy. Feature wise it is getting up there. From my experience > it > > is certainly up there in relation to speed and it has a few nice features > > that MSSQL doesn't have. > > > > -----Original Message----- > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On > Behalf > > Of Dale Fraser > > Sent: Monday, 24 September 2007 8:45 PM > > To: cfaussie@googlegroups.com > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition > > > > > > I understand why you would like it. > > > > But MySQL is a toy and it makes sense > > > > MSSQL is for large databases, I don't see how this would work to backup > > gig's of database to some remote disk. In fact I can't see it working very > > well on any database of any reasonable size. > > > > Regards > > Dale Fraser > > > > http://learncf.com > > > > -----Original Message----- > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On > Behalf > > Of Andrew Scott > > Sent: Monday, 24 September 2007 5:55 PM > > To: cfaussie@googlegroups.com > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition > > > > > > Nice if you have full access to the server? > > > > But this is a shared host, and I have 1 MS SQL databases and 2 mySQL > > databases and the MS one I have to get them to back up and place in my ftp > > for me to download. With the mySQL ones I backup to my desktop and have no > > hassles restoring to a database server here, with no interaction with > > support. > > > > Are you seeing the point now? > > > > > > On 9/24/07, Dale Fraser <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > Backup > > > > > > > > > > > > Ftp > > > > > > > > > > > > > > > Regards > > > > > > Dale Fraser > > > > > > > > > > > > http://learncf.com > > > > > > > > > > > > > > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On > > Behalf > > > Of Andrew Scott > > > Sent: Monday, 24 September 2007 4:44 PM > > > > > > To: cfaussie@googlegroups.com > > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition > > > > > > To: cfaussie@googlegroups.com > > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition > > > > > > > > > > > > > > > > > > Scott, > > > > > > > > > > > > How does that help me, backup a database remotely to my local machine? > > > The only options are to the servers hard drive, or tape? > > > > > > > > > > > > Andrew Scott > > > Senior Coldfusion Developer > > > Aegeon Pty. Ltd. > > > www.aegeon.com.au > > > Phone: +613 8676 4223 > > > Mobile: 0404 998 273 > > > > > > > > > > > > > > > > > > > > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On > > Behalf > > > Of Scott Barnes > > > Sent: Monday, 24 September 2007 4:18 PM > > > To: cfaussie@googlegroups.com > > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition > > > > > > > > > > > > > > > Umm Define easy? > > > > > > > > > > > > > > > > > > eg: > > > http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 9/24/07, Andrew Scott <[EMAIL PROTECTED]> wrote: > > > > > > > > > Scott, > > > > > > > > > > > > You might be the man to pass on a suggestion for the next version off > > > MS SQL. > > > > > > > > > > > > One of the things that has annoyed me the most, is remote database > > backups? > > > Why is it not easy to do, and when transferring data remotely to local > > > you are not 100% guaranteed the data is exact. I find this very > > > frustrating > > with > > > the product, I have found that even dropping the tables and copying > > > the > > data > > > is annoyingly broken. Maybe I am dumb towards the product, but there > > > seems to be a hell of a lot of features gone in EM. > > > > > > > > > > > > I love mySQL Administrator because I can backup and restore a schema > > > remotely from/to my HD locally. > > > > > > > > > > > > Would be so nice to see these enhancements very soon as a Service Pack > > > or something. > > > > > > > > > > > > > > > > > > Andrew Scott > > > Senior Coldfusion Developer > > > Aegeon Pty. Ltd. > > > www.aegeon.com.au > > > Phone: +613 8676 4223 > > > Mobile: 0404 998 273 > > > > > > > > > > > > > > > > > > > > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On > > Behalf > > > Of Scott Barnes > > > Sent: Monday, 24 September 2007 3:17 PM > > > To: cfaussie@googlegroups.com > > > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition > > > > > > > > > > > > > > > You can get it in two editions, Express and obviously with the > > > enterprise edition. That being said, you can manage the basics of a > > > SQL 2005 server with the Studio Express edition... > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > Senior Coldfusion Developer > > Aegeon Pty. Ltd. > > www.aegeon.com.au > > Phone: +613 8676 4223 > > Mobile: 0404 998 273 > > > > > > > > > > > > > > > > > > > > -- > > > > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 > > > > > -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
