Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Trying to copy database from my laptop to my desktop pc


Trying to copy database from my laptop to my desktop pc

Author
Message
nerd_buzz
nerd_buzz
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 11
Hi, as you can tell i am a nube here. I am trying to copy SQL database established locally on my laptop and copy it to my desktop pc so i can practice running queries on there. I have tried to migrate and i failed. i have the password for the schema created on my laptop. now am i trying to create a new schema on my desktop? or do i copy the schema also? i am also unable to pass the "test connection" when i create any new schema on my desktop. please help
AndrewSQLDBA
AndrewSQLDBA
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1008 Visits: 3427
The most simple way would be a backup and restore. I am assuming the two boxes are on the same network, or in the same domain. Create a full backup, copy it to the other box, perform a restore over the empty database that you just created.

Andrew SQLDBA
nerd_buzz
nerd_buzz
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 11
@ Andrew, when you say " two boxes are on the same network", i share the same home network. these are merely just practice databases so i can practice on my desktop as well as my laptop. And what do you mean on the same domain? do you mean create exact same schema on my desktop? and am i using RMAN to backup and restore? or what tool because google says its not possible to back up and recover viz oracle sql developer.

Thanks for all your help Andrew.
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47183 Visits: 44356
A SQL Server database backup. So from SQL Server Management Studio, right click the database Tasks-> Backup. Copy the backup file that's created over to your other machine and restore it (Open management studio, right click the databases folder, restore database)


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


nerd_buzz
nerd_buzz
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 11
i am not using SQL Server Management Studio. I am using orcle sql developer verison 1.5.3 on my laptop and ver 3.2.20.09 on my desktop.
AndrewSQLDBA
AndrewSQLDBA
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1008 Visits: 3427
You did not mention these are on you own network. So there will most likely not be a domain. I was giving you info on how to copy the file from one box to the other.

I would strongly suggest that you use the tools that come with SQL Server if you are going to use SQL Server. They are better than any other.

As Gila stated, a full backup and restore. On the box where you want to restore. Simple create a database, you can name it the same name or not. It does not matter. Then follow the instructions that Gila sent on restoring a database.

Simple as that.

Andrew SQLDBA
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47183 Visits: 44356
nerd_buzz (5/11/2013)
i am not using SQL Server Management Studio. I am using orcle sql developer verison 1.5.3 on my laptop and ver 3.2.20.09 on my desktop.


Why would you use an Oracle dev tool when all versions of SQL Server (including express) come with SQL Server Management Studio?


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47183 Visits: 44356
AndrewSQLDBA (5/11/2013)
Simple create a database, you can name it the same name or not. It does not matter. Then follow the instructions that Gila sent on restoring a database.


Err.. why create a database first?


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


AndrewSQLDBA
AndrewSQLDBA
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1008 Visits: 3427
I always create them first, one to be able to set the directories where I want. I know.... I could do it all on the restore, just the way I do it.

Andrew SQLDBA
nerd_buzz
nerd_buzz
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 11
well the only reason i m using oracle dev is because my so called "teacher" loaded it on my computer and told me to practice on it with a database he loaded on my system. But i am willing to try the oracle server. is that available on the oracle website for free? like i said i am nube so i am getting some practice done while i am trying to finish my OCP.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search