On Tue, Jan 6, 2009 at 12:52 AM, Mike Kear wrote:
@jochem, the reason you have to do the copy
I understand the technical challenge in implementing the workflow. My
question was more related to why you would want the workflow to work
the way it does.
Hosting companies (including mine) take
I hate to ask - but if you copy the data from the live server to
your testing server, make a change to the database on your testing
server then upload the database structure and data back to the live
server, what happens to any new data collected on the live server in
the time it takes you
On Tue, Jan 6, 2009 at 1:00 AM, Jochem van Dieten joch...@gmail.com wrote:
We always put a hook in onApplicationStart() to read the schema
version number from the database and if the database schema is out of
date it will run the SQL scripts to update the schema.
That's a slick idea Jochem, I
Quite right, Al, on sites that collect user data on the production
database. Other sites just have a CMS system that is build on a
database and there is no change to teh production database from one
week to the next.
It all depends on the applications that are running on the site and
how they
I didn't name them. Just love them. :-)
On Sun, Jan 4, 2009 at 11:30 PM, Mike Kear afpwebwo...@gmail.com wrote:
huh? the COMPARE product is the one that copies data and structure
between two servers??? Really??
Cheers
MIke Kear
On Mon, Jan 5, 2009 at 4:28 PM, John M Bliss
on the production one.
Richard
-Original Message-
From: Paul Kukiel [mailto:pkuk...@gmail.com]
Sent: 05 January 2009 14:52
To: cf-talk
Subject: Re: How do you guys deploy databases to shared servers?
Yes these are the 2 that I use. I haven't even used the rest of them.
Regards,
Paul
On Mon, Jan 5
One more tool to offer -- might be the one for you because it's free.
EMS SQL Manager Lite
(http://sqlmanager.net/en/products/mssql/manager/download) has an
extract database function (Tools Extract Database) which creates
the database tables, dependent objects, and inserts for the data.
Pete
What a big disappointment, Dave.
Since I started receiving all the enlarging spam, I haven't heard
that a lot lately. Oh well.
So instead i have to have the tool create a big SQLscript. I have to
run a 85MB SQLscript. by cutting and pasting it into my Query
Analyser. It's been running 8
+1 for Red Gate's SQL Compare and SQL Data Compare. Used to use them whenever
a developer would get a production DB out of sync with the staging DB: very
quick to figure out what key got missed, and it will gen the script to make A
like B or B like A.
DTS functions were moved to SSIS (SQL Server Integration Services). There
is a wizard in there which will migrate your old DTS package into SSIS. The
SSIS language and format is different than DTS so they need to be imported
or re-written. That's as far as I can take you. Our company is
Yes these are the 2 that I use. I haven't even used the rest of them.
Regards,
Paul
On Mon, Jan 5, 2009 at 12:28 AM, John M Bliss bliss.j...@gmail.com wrote:
I can't live without Red-Gate...
Which of them do you use to copy/duplicate/synchronise
FWIW, I'm in the process of writing (well, it's probably more
accurately one of those things that works, but will never really be
done) a CF8 script that rips through a database, creates insert
statements (option to include truncate statements and also sets
identity insert on/off), and saves the
An unhelpful observation:
I just migrated a guy off of SQL Server and onto mySQL so we could
handle this sort of thing so much more smoothly. SQLYog has a
command-line utility you can schedule that will do as many one-way or
two-way synchs as desired and don't require the db to be taken
offline.
Red-Gate's answer to this (for SQL Server) is
http://www.red-gate.com/products/SQL_Comparison_SDK/ (I think)
No, I do not work for Red-Gate. :-)
On Mon, Jan 5, 2009 at 4:00 PM, Matt Robertson websitema...@gmail.comwrote:
An unhelpful observation:
I just migrated a guy off of SQL Server and
On Mon, Jan 5, 2009 at 1:30 AM, Mike Kear wrote:
I'm heartily sick of the tedious way I have to spend half a day or
more EACH WEEK uploading and downloading databases from my
SQLServer2005 web sites.
The thing I don't understand is why you would do all that uploading
and downloading in the
@jochem, the reason you have to do the copy is because without
system administrator privileges, you cant use any of the features
built in to SQLServer - you can use backup/restore, you cant use the
copy database wizard, you cant use the synchronise functionality. In
a shared hosting
I'm heartily sick of the tedious way I have to spend half a day or
more EACH WEEK uploading and downloading databases from my
SQLServer2005 web sites.
I'm going to have another go at learning the best way to do this . .
Can someone please give me some help...IN the old days I used to have a
check out sql litespeed for very quick and powerful backup and
restore. Can be a handy way to move them about - although I must
admit I'm out of date now as I tend to stick to postgresql and mysql
which have very simple porting methods.
Toby
On 05/01/2009, at 11:30 AM, Mike Kear wrote:
Thanks Toby.Does it allow you to back up and restore if you dont
have administrator priveleges? That's the problem with shared
hosting - Microsoft dont seem to have made any provision for database
owners to do any of these tasks, only server administrators.
Obviously, on a shared system
actually that may be a problem - sql litespeed works via a number of
stored procedures you install, but I'm afraid I can't remember the
permission requirements either for install or use. There's a free
demo though, so you can give it a try.
Toby
On 05/01/2009, at 11:48 AM, Mike Kear wrote:
I'm heartily sick of the tedious way I have to spend half a day or
more EACH WEEK uploading and downloading databases from my
SQLServer2005 web sites.
Not that it helps you any, but this is exactly the reason I've moved most of my
websites to MySQL. Navicat makes this kinda thing completely
I'll second that on navicat - worth the very small fee for the pro
version even. The ability to just select a source and destination db
and copy al structure and or data automatically is wonderful. Doesn't
matter whether the source or destination are local or remote or both.
Toby
On
Can someone please give me some help...IN the old days I used to have a
DTS task running overnight automatically, copying databases to and
from my dev environment to the production web sites.
Have you tried this?
No I havent, Dave, and I'm surprised that in all the whinging I've
done to Microsoft in the last 3 years, no one there has mentioned it.
I'ave gone at them over this issue so many times, i have had to ease
off in the last few months lest i be classed as a vexatious support
caller and get myself
We recently got Red gates toolbelt SQL tools. Like you upgrading/
moving databases was time consuming and difficult. Now its just so
much easier. http://www.red-gate.com/products/
SQL_Professional_Toolbelt/index.htm
Paul Kukiel
On 04/01/2009, at 7:30 PM, Mike Kear wrote:
I'm heartily
What a big disappointment, Dave. It wont connect to a remote database
to update, only to a web service. Who the hell inserts 40,000 records
into a database using a web service???
So instead i have to have the tool create a big SQLscript. I have to
run a 85MB SQLscript. by cutting and pasting
Thanks Paul. I see those Red gates packages are a series of $395
applications. My tiny company isn't going to afford $5000 worth of
tools, or even the bundle price around $1000.
Which of them do you use to copy/duplicate/synchronise databases
between two servers?
Cheers
Mike Kear
Windsor,
How long does it take to publish a database using that database
publishing wizard?? I have had the 85MB SQL script running now for
28 minutes (and counting), giving my users database errors all that
time.
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
I can't live without Red-Gate...
Which of them do you use to copy/duplicate/synchronise
http://www.red-gate.com/products/SQL_Compare/ for DB structure.
http://www.red-gate.com/products/SQL_Data_Compare/ for DB contents.
On Sun, Jan 4, 2009 at 10:55 PM, Mike Kear afpwebwo...@gmail.com wrote:
huh? the COMPARE product is the one that copies data and structure
between two servers??? Really??
Cheers
MIke Kear
On Mon, Jan 5, 2009 at 4:28 PM, John M Bliss bliss.j...@gmail.com wrote:
I can't live without Red-Gate...
Which of them do you use to copy/duplicate/synchronise
30 matches
Mail list logo