[dba-SQLServer] Transferring a database to another SQL

Okay John,

Now I understand more.

Since these are both SQL 2000, if I remember the thread correctly, 
can you connect to them through DTS on one of the machines?

If so, and you have the drive space on the second machine, you can 
use DTS to move the data between the two machines.

I am with you on moving hardware between machines.  I hate 
hardware.  But deal with it because I cannot afford a consultant to 
deal with it for me.

Robert

At 01:00 PM 8/29/2006, you wrote:
>Date: Tue, 29 Aug 2006 11:36:37 -0400
>From: "JWColby" <jwcolby at colbyconsulting.com>
>Subject: Re: [dba-SQLServer] Transferring a database to another SQL
>         Server
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <003c01c6cb80$ebd6e7a0$657aa8c0 at m6805>
>Content-Type: text/plain;       charset="us-ascii"
>
> >The simple answer was given to him (JC) in the first post back to him.
>Which is why I never chimed in.
>
> >Detach it.
> >Copy it to the other machine.
> >Attach it.
>
>In fact that is only one of my two questions, but given my reception on the
>other question I suppose I should just not ask again.
>
>In fact I have RTFM (in advance of even asking AAMOF) and I found stuff
>about disconnecting / reconnecting possibly causing "orphaned users", this
>being caused by the use of something like a PK from the OS user to represent
>the user in the SQL Server login, and even though the user name is the same
>on the two machines, the UserID is not necessarily the same.  It does make
>me a bit leery of going the disconnect route.
>
>I had hoped to get both machines seeing the other (SQL Servers) and then see
>if I could just query directly out of a table in one SQL Server and transfer
>the data into the same table (new/empty) in the other SQL Server.  I know I
>can export the data to text files and then re-import back in, but given the
>fact that the data is hundreds of gigabytes, I don't even want to go there
>if I can avoid it.
>
>Unfortunately I do not know enough about SQL Server / networking to
>troubleshoot the "why" of two servers not seeing each other, and given that
>the list Gurus specifically want me to go become a SQL / Notwork DBA before
>I ask such questions, it seems that I will get no assistance on that here.
>
>I have the database on 5 250gb drives, which I suppose I shall disconnect
>and then simply move the entire disks and pray for the best.
>
>There are other forums I belong to though, I'll also go see if anyone can
>help.  This is going to be a lot of data and eventually I will need machines
>preprocessing and then shipping the results to a central server, so the
>servers really do eventually need to see each other I think.  It should be
>fun, and I should learn a lot, though perhaps not here.
>
>Thanks Stewart,
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com