SQL Clone
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
AndrewSQLDBA
AndrewSQLDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4720 Visits: 3427
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
nerd_buzz
nerd_buzz
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 11
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.
AndrewSQLDBA
AndrewSQLDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4720 Visits: 3427
[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
nerd_buzz
nerd_buzz
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 11
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?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)

Group: General Forum Members
Points: 232731 Visits: 46361
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

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


GilaMonster
GilaMonster
SSC Guru
SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)SSC Guru (232K reputation)

Group: General Forum Members
Points: 232731 Visits: 46361
AndrewSQLDBA (5/11/2013)
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


pl/sql is set-based as well, though it has a lot of procedural aspects (pl-SQL actually stands for procedural SQL). pl-sql is in fact a much more complete language than T-SQL (at least comparing the pl-sql I used to write 10 odd years ago). Later versions of pl/sql have object-orientated aspects, allowing declaration of classes for example

Calling one 'more advanced' than the other is a disservice to both, they are very different languages even though they're both based on the ANSI standards. pl/sql kinda resembles a cross between ANSI sql and PASCAL

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
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4720 Visits: 3427
Gail
Thank you for the clarification. I learned something new. I was taking my judgement from my experience years ago with PL-SQL.

Hope that you have a good day.

Andrew SQLDBA
subhajeetsur
subhajeetsur
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 27
Take backup of database and restore the same in diff machine. i guess u r referring to oracle server, you can get the same in oracle websites
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