[dba-SQLServer] Transferring a database to another SQL Server

Francisco Tapia fhtapia at gmail.com
Wed Aug 30 11:15:46 CDT 2006


Either platform works either the VMware Server wich is also free as in
beer, or the Virtual Server from MS,  FYI, i've had better luck w/ the
VMware server than the MS one. (FYI).


--
Francisco

On 8/30/06, Martin Reid <mwp.reid at qub.ac.uk> wrote:
> John
>
> You may want to consider Virtural Server OS for this. Its worth looking at.Set up Windows Virtual Server 2005 which is free and work from there.
>
> I have emailed you a contact of list who deals with all my server side stuff in the University. He may be slow to respond but he knows this stuff inside out and should be able to advise or at least give you access to someone who is an expert (no disrespect to all here) on the network and OS side of things.
>
> Martin
>
> Martin WP Reid
> Training and Assessment Unit
> Riddle Hall
> Belfast
>
> tel: 02890 974477
>
>
> ________________________________
>
> From: dba-sqlserver-bounces at databaseadvisors.com on behalf of Jim Lawrence
> Sent: Wed 30/08/2006 03:41
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Transferring a database to another SQL Server
>
>
>
> Hi John:
>
> You have an interesting catch 22 situation. MS SQL server will not fully
> optimize on just a work station and needs a server based environment to be
> able to deliver all of its services. There are some issues with WFWG and SQL
> server... as you are well aware.
>
> So now that you have simple networking off you will have to add a user(s) to
> one station and another one to the other; see your computer management on
> each box to do this:
>
> c:\windows\system32\compmgmt.msc.
>
> Then go to the root of each station and each drive and share it. It default
> names will be c$ (c drive) d$ (d drive) etc. Make sure that every new user
> you create on one computer is part of the administration group (god-like).
>
> If one station  called 'station1' has a god-like user named 'user1' with
> password 'password1' which have been added to the station1's c$ and d$ share
> (high-light drive root, right-mouse click, select properties, tab security,
> add button, select new god-like user, tick all rights, apply and OK.)  All
> another station has to do to have complete access is to 'log in to' station1
> using user1, password1.
>
> Note c$ and d$ are hidden shares so you will have to key them in directly
>
> I hope the above makes sense as I am typing fast as I can as I am 10 minutes
> late already. Will ask any questions later.
>
> Jim
>
> PS This from a security stand-point is an absolute no-no but do we care,
> full connection is the name of the game.
>
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby
> Sent: Tuesday, August 29, 2006 5:12 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Transferring a database to another SQL Server
>
> Nope.  All machines are Windows XP Professional.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
> Lawrence
> Sent: Tuesday, August 29, 2006 6:20 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Transferring a database to another SQL Server
>
> Hi John:
>
> Is one of your computers a server like 2000 or 2003? If so you can connect
> in about half dozen steps.
>
> Wait for confirmation...
>
> Jim
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby
> Sent: Tuesday, August 29, 2006 11:35 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Transferring a database to another SQL Server
>
> Yes, that is what I was asking kinda.  In this case all I need to do is move
> the entire database.  In the future I really want to have one machine
> process data from text files, do address correction / validation, get tables
> entirely set up and functioning and then transfer just that table to another
> server.  Or perhaps even leave the table out on the machine it started on
> and attach to the table from the other server instance.
>
> ATM, neither machine can see the other, ether disk shares, nor server
> instances.  I suspect that file shares will be the easiest of the two
> problems to fix and I need to get that happening regardless.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
> Lawrence
> Sent: Tuesday, August 29, 2006 12:52 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Transferring a database to another SQL Server
>
> Hi John:
>
> If it just requires moving the index and data files to the other computer,
> then attaching them that can be done as simply as copying the two important
> files from computer A to computer B. Given a database named MyDatabase just
> copy from directory ie: c:\Program Files\Microsoft SQL Server\MSSQL\Data
> files named MyDatabase.ldf and MyDatabase.mdf to the other computer or
> simpler yet just attach (MS SQL 2005), Microsoft SQL Server Management
> Studio > databases > right-mouse-click > select Attach > select Add and then
> just navigate to your computer that has the (data) MyDatabase.mdf file and
> select it.
>
> Is this what you are asking?
>
> HTH
> Jim
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby
> Sent: Tuesday, August 29, 2006 8:37 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Transferring a database to another SQL Server
>
> >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
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert L.
> Stewart
> Sent: Tuesday, August 29, 2006 10:16 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Transferring a database to another SQL Server
>
> As to why we are all here, it is to learn and hopefully help when we KNOW
> the answer.
>
> 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.
>
> KISS - Keep it Supremely Simple
>
> Always works for me.
>
> Robert
>
> At 08:40 AM 8/29/2006, you wrote:
> >Date: Tue, 29 Aug 2006 10:17:25 +0930
> >From: "Haslett, Andrew" <andrew.haslett at ilc.gov.au>
> >Subject: Re: [dba-SQLServer]
> >         [AccessD]TransferringadatabasetoanotherSQLServer
> >To: <dba-sqlserver at databaseadvisors.com>
> >Message-ID:
> >
> ><0A870603A2A816459078203FC07F4CD2BE403C at adl01s055.ilcorp.gov.au>
> >Content-Type: text/plain;  charset="utf-8"
> >
> >Suit yourselves - Seems to be a bit of a 'boys' club who are quite
> >happy to ask for advice but only accept it when its something they want
> >to hear, and ignore it otherwise (demonstrated throughout the post
> >below)
> >
> >The points I made in my post apply to anyone looking to undertake
> >similar issues, and will continue to happen until someone has the guts
> >to say it, irrelevant of who it is aimed at (which is how it should be
> >-> on a public forum, favour or protection should not be given to
> >anyone simply because they are friends, associates or seniority).
> >
> >Ask yourself this -> Would you have made the same post Jim, had it not
> >have been aimed at Mr Colby?.
> >
> >Stark realities occasionally need be surfaced in order for them to sink
> >in.. Irrespective of the target or consequences.  Was it harsh?
> >Yup.  Could it perhaps prevent someone else from making the same
> >mistakes and undertaking projects without due preparation and planning?
> >Hopefully, and therefore I believe useful.
> >
> >John asked Stuart "Why are you here then?".   Some of us prefer to
> >assist others, pass on what knowledge they can and in my case attempt
> >to 'help others, help themselves', as opposed to just feeding of
> >others.
> >
> >I know of a number who have left this (and the Access) list in the
> >past, including myself, for similar reasons and 'Matesmenship' in the
> >upper echelons.
> >
> >Please unsubscribe me from the list.
> >
> >Andrew
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com <http://www.databaseadvisors.com/>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com <http://www.databaseadvisors.com/>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com <http://www.databaseadvisors.com/>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com <http://www.databaseadvisors.com/>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com <http://www.databaseadvisors.com/>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com <http://www.databaseadvisors.com/>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com <http://www.databaseadvisors.com/>
>
>
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
>
>


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...



More information about the dba-SQLServer mailing list