On Dec 14, 1:05 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> Hi Louis,
>
> How did you exactly export you databases?
>
> Normally the easiest way to move databases is to backup, move the backup
> file to the new PC, and then restore.
>
> You could also use detach, copy the MDF and LDF files, then attach on the
> new PC (but you have to attach back to the original PC too, if you need the
> databases there). Not worth the trouble unless you do not have space to save
> a backup file.
>
> Alternatively you can script your database objects and export the data, then
> apply the scripts to the new PC and import the data. This is manual approach
> that is not needed unless you want to change structure for some objects
> during the transfer, filter data, etc.
>
> HTH,
>
> Plamen Ratchevhttp://www.SQLStudio.com


Hi Plamen,

Thanks for your reply.

I created a new local db and imported the tables from the live
database, selecting "copy objects and data between SQL Server
databases", then left "copy all objects" and "use default options"
selected on the next step, then I selected "run immediately" but
didn't save the DTS package.
Do I need to take the live db offline in order to do this (I get a
failure message halfway through the import process).

Thanks,
Louis