detailed comparison between Oracle and SQLserver

[Former Member]

I am very good at Oracle. Now I start to use other DBs such as SQL.

I would compare Oracle and SQL server.

Could anybody help give the full path of the following files' equavalents?

alert_SID.log

initSID.ora

listener.ora/tnsnames.ora

controlSID.dbf

oratab

Also some Oracle tables/views' equavalents:

sapusers

V$backup

v$database

v$instance

Do not have to exactly the same. Similar ones would be enough.

Thanks and points.

[Former Member]

Hope this helps.

Also some Oracle tables/views' equavalents:

sapusers

MSS = sys.sysusers and sys.sql_logins for SQL users eg sa.

V$backup

MSS = dbo.backupset (msdb)

v$database

MSS= sys.databases

v$instance

Depends how literal you want to be. by default in SQL you installed in the default (no name) instance. I dont know the table that holds this.

as a rule in MSS system table will begin with sys or dbo like in oracle they begin with V%

alert_SID.log

c:\prog files\microsoft sql server\mssql1\mssql\log\sqlagent.out

errors are also written to the windows event logs too.

initSID.ora

no such thing

listener.ora/tnsnames.ora

This is via the registration of a server . ie you want to add another one just right clicking on the existing one and select register

controlSID.dbf

These are via startup option ie -m for single user mode. you use this via the sortcut and just add the letters in. Master Database looks after data about the other databases in the system.

oratab

This is just a mapping entry - not needed on MSS.

[Former Member]

if you have SAP system installed on the SQL server,

you can also use transaction DB02

[Former Member]

Can you also compare some commands:

drop user XXX cascade

commit ( how to rollback the last transaction in SQLserver)

create table XXX as select * from table YYY;

alter user identified by "pass"

what is above's equavalent in SQLserver? Thx.

and is there a user called OPS$<SID>ADM in SQLserver?

Message was edited by:

jennifer lee

[former_member193399]

Q: commit ( how to rollback the last transaction in SQLserver)

A: if you are using Query Analyzer the transactions are automatically commited once you execute unless there is a begin transaction.

Q: create table XXX as select * from table YYY;

A: select * into XXX from YYY

Q: is there a user called OPS$<SID>ADM in SQLserver?

A: There is no user caled OPS$<SID>ADM. The users are SAP<SID>DB for the schema SAP<SID>DB and <sid> with the buildadmin, dbcreator and serveradmin server roles.

I hope this helps.

Thanks,

RT

[Former Member]

Try to use the enterprise manager,

you can find there everything:

users, authorizations, tables, current threads, system errors and etc...

if this helps, does forget to award me...