May 11, 2013 at 10:24 am
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
May 11, 2013 at 11:31 am
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
May 11, 2013 at 11:50 am
@ 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.
May 11, 2013 at 12:36 pm
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
May 11, 2013 at 1:56 pm
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.
May 11, 2013 at 2:47 pm
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
May 11, 2013 at 4:23 pm
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
May 11, 2013 at 4:25 pm
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
May 11, 2013 at 4:31 pm
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
May 11, 2013 at 7:09 pm
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.
May 11, 2013 at 7:23 pm
You will have to post that on an Oracle forum, this is a SQL Server forum. SQL and Oracle do not play well together.
Another thing, What are you doing allowing anyone to load software on your box? How do you know what else they did?
Andrew SQLDBA
May 11, 2013 at 7:29 pm
ok i will find and an oracle forum. sorry to post on the wrong forum. like i said a nube here. And really oracle doesnt go well with SQL? thats the first time i m heariing that considdering wherever i have read oracle consists of sql and pl/sql. not to mention everyone has told me that its a great line to go into oracle. Also i trust this guy, he is not some guy off the road. he has been a DBA for quite a while now over 10+ years. he barely has time but i learned how to program c with a book and online forums so i figured i could do this also.
May 11, 2013 at 7:36 pm
[SQL] is a language, not an application or database server. [SQL Server] as with all other relational and non-relational databases systems use [SQL] as the language that is used to query/manage the database system.
pl-sql is different that t-sql pl is Oracle based, which is cursive based. SQL Server is set based and uses t-sql Much more advanced language than pl-sql
Andrew SQLDBA
May 11, 2013 at 8:47 pm
thank you so much for your input andrew. may i ask which one has more jobs available? which on pays more? and is more stable platform for the future? is it bad to get my OCP via oracle testing? should i not do pl/sql? i only have 2 tests left to complete my ocp. is oracle a bad platform?
May 12, 2013 at 2:48 am
This is a Microsoft SQL Server site, not a generic, any database engine site. Specifically this forum is for Microsoft SQL Server 2008. We're SQL Server people here, not Oracle users for the most part.
May I suggest http://www.dbforums.com? They have an Oracle section.
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
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply