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 ma
On Tue, Jan 6, 2009 at 1:00 AM, Jochem van Dieten 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 like that. Wo
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 t
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
@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 environmen
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 f
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 wrote:
> An unhelpful observation:
>
> I just migrated a guy off of SQL Server and onto mySQL so we cou
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.
n 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
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 wrote:
> 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 str
> 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 runn
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 migr
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
+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.
~
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
I didn't name them. Just love them. :-)
On Sun, Jan 4, 2009 at 11:30 PM, Mike Kear 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 wrote:
> > I can't live
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 wrote:
> I can't live without Red-Gate...
>
>> Which of them do you use to copy/duplicate/synchronise
>
> http://www.red-gate.com/p
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 wrote:
> Thanks Paul. I see
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
AFP
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, NSW,
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
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
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
> 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?
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0
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 05/01
>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 b
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:
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 wher
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:
>
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
DT
30 matches
Mail list logo