ajsolimine wrote:I suppose my first question would be why you're trying to do this with> We've recently started work on a website where the SQL datasources reside on a
> drive without much space. We therefore want to migrate the all the data
> sources from the C:\ drive to D:\ drive. I've been unsuccessful in uncovering
> much doentation. Is this as easy as (after backing up the data) moving the
> data to the new drive and reattaching to the new location of the data source?
> Are there other potential problems that I need to consider?
> Basically, I am looking for a description of the process of migrating MS SQL
> 2000 Data files with coldfusion.
CF? Not that it's not doable, but migrating SQL Server databases (which
is what I assume you're talking about) from one drive to another is
really just a matter of either doing a backup and restore (at which
point you can tell SQL Server where you want the files to reside) or
detach the database, move the mdf file, and reattach the database. Does
CF come into this picture because you have a lot of them to do and don't
want to do them each individually?
Also remember that pretty much anything that's possible via a wizard in
SQL Server can be done with T-SQL commands as well (which is what
enterprise manager does behind the scenes), so it's probably more a
matter of determining what you need to do and how to do it in T-SQL,
then if you want to get CF involved it would probably just be a mixture
of cffile and cfquery that would get the job done.
Team Macromedia - ColdFusion