Re: How do people transfer data between databases nowdays?

2010-03-04 Thread Jason Fisher
Good to know, thanks. My next trick is to get a 356 MB script to run LOL ... time to break things up, I guess. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing

Re: How do people transfer data between databases nowdays?

2010-03-04 Thread Matthew Smith
I've had issues where it puts the view creation before the tables that the view uses, causing an error when run. Just keep an eye out for that. On Wed, Mar 3, 2010 at 6:03 PM, Jason Fisher wrote: > > Nice, I hadn't ever seen that tool before. Can't wait to give it a > spin. Thanks! > > > > O

Re: How do people transfer data between databases nowdays?

2010-03-03 Thread Jason Fisher
Nice, I hadn't ever seen that tool before. Can't wait to give it a spin. Thanks! On 3/3/2010 5:08 PM, Matthew Smith wrote: > I use this. Simple, works. > > http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en > > On Wed, Mar 3, 2010 at

Re: How do people transfer data between databases nowdays?

2010-03-03 Thread Matthew Smith
I use this. Simple, works. http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en On Wed, Mar 3, 2010 at 12:23 AM, Mike Kear wrote: > > Now that my dev machine is being rebuilt, one of the things i have to > do is work out if the way I've

Re: How do people transfer data between databases nowdays?

2010-03-03 Thread Dave Watts
> I'm using the free SQLServer Express and would you believe it - import > and export is one of the disabled features.    A kind person suggested > Toad SQLServer edition - but i cant see how to transfer data between > databases there either.     There's an export feature, but unless i'm > missing

RE: How do people transfer data between databases nowdays?

2010-03-03 Thread Josh Nathanson
ch of work for you. -- Josh -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Wednesday, March 03, 2010 9:10 AM To: cf-talk Subject: Re: How do people transfer data between databases nowdays? I say again: http://www.red-gate.com/products/SQL_Data_Compare/ On We

RE: How do people transfer data between databases nowdays?

2010-03-03 Thread Josh Nathanson
Wednesday, March 03, 2010 9:10 AM To: cf-talk Subject: Re: How do people transfer data between databases nowdays? I say again: http://www.red-gate.com/products/SQL_Data_Compare/ On Wed, Mar 3, 2010 at 11:05 AM, Mike Kear wrote: > > Thanks Will, but the problem at issue is how do people

Re: How do people transfer data between databases nowdays?

2010-03-03 Thread John M Bliss
I say again: http://www.red-gate.com/products/SQL_Data_Compare/ On Wed, Mar 3, 2010 at 11:05 AM, Mike Kear wrote: > > Thanks Will, but the problem at issue is how do people move data from > the staging/dev MSSQL machines to the production MSSQL machines, if > the following limitations apply: >

Re: How do people transfer data between databases nowdays?

2010-03-03 Thread Mike Kear
Thanks Will, but the problem at issue is how do people move data from the staging/dev MSSQL machines to the production MSSQL machines, if the following limitations apply: [A] No console access because it's a shared host so therefore can't take a backup, FTP It to the remote machine and restore it

Re: How do people transfer data between databases nowdays?

2010-03-03 Thread Will Tomlinson
>Now that my dev machine is being rebuilt, one of the things i have to >do is work out if the way I've been doing things is still the best way >of doing them. > > +1 dbconvert.com. They have an amazing slick application there. I happen to use it to convert MSSQL > MySQL. Works like a charm. ~~

Re: How do people transfer data between databases nowdays?

2010-03-03 Thread John M Bliss
I use http://www.red-gate.com/products/SQL_Data_Compare/ Cannot live without it. While you're at it, be sure to pick up a copy of http://www.red-gate.com/products/SQL_Compare/ or just buy http://www.red-gate.com/products/sql_bundles/SQL_Comparison_Bundle.htm which includes both. On Wed, Mar 3,

Re: How do people transfer data between databases nowdays?

2010-03-03 Thread Mary Jo Sminkey
>So how does everyone upload data to their shared hosting remote databases?? > I don't know of anything to do this specifically built just for MSSQL but I've become a big fan of the convert/sync tools made by the folks at dbconvert.com, and they do have ones that could handle this type of thing

How do people transfer data between databases nowdays?

2010-03-02 Thread Mike Kear
Now that my dev machine is being rebuilt, one of the things i have to do is work out if the way I've been doing things is still the best way of doing them. The subject that's exercising my mind right now is how to transfer data between my staging MS SqlServer2005 database and the production datab