Ryan, Cheers but we own Red-Gate SQL Bundle becuase of those exact limitations in MS SQL 2005.
On 9/25/07, Ryan Sabir <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
