OracleDBA need help on SQLSERVER tool

Hi, I am an oracle DBA, now I am just assigned todo something over our SQLSERVER database. I don't know anything about SQLSERVER. So far, I have SQLSERVER Enterprise Manager Client on my machine. I can't find anywhere that has something like Oracle's SQLPlus where I can run scripts, it seems the EM tool can only run query against one table at a time by clicking that table...I may be wrong though. Can someone gives me some hints?

My main responsibility is to move those sqlserver data to oracle database, I find there is export utility in sqlserver EM that I can use to move data. But I also need to run some query to check if the migration is error free. so my questions are:

How I can create links to Oracle (or is it possible?) and is it possible to run the query against oracle from sqlserver? any document links?

Anyplace I can run the sql scripts instead of right click each table?

Can anyone point me to some documents for a sqlserver beginner?

Thanks in advance.

If you are running enterprise manager, I would assume you are on SQL 2000. If so, Select Tools, Query Analyzer.

This is a GUI for running any SQL.

HTH

|||
Hi, Bob:

I got the query tool, thanks a lot.

Any one can give me a hint as to how to create links within sqlserver to oracle database?

Thanks in advnace

Oracle/Unix Environments --> SQL Server 2005/Windows 2003 Server

I was a Oracle Developer / DBA on Unix Environments all along my career, Very recently iam starting to manage a SQL Server 2005/Windows 2003 Server setup.

Part of my new job is to automate to load Huge Data files/Flat Files (3/4 GB in size) into SQL Server 2005 DB.

Have these initial questions..
Since the files are too large to open at once... What sort of Command Line Interfaces people use on the Windows Boxes.. like doing a "wc" (Word Count) / GREP 'ng Files / Massaging Data Files one line at a time (Like using SED / AWK Commands).. Etc

Any Input / Direction is appreciated...

The data load took for SQL Server is called BCP. It's a command line tool.

The typical practice would be to load all the data into a holding table, then massage it within SQL with T/SQL code.

When working with data inside of SQL Server don't forget that SQL Server doesn't like cursors like Oracle does. Do as much as possible with SET based commands.

|||Thanks for your response..

We are using SSIS as our Data Loading Tool for now..
However, if you were to look at the last record in a HUGE data file.. How do you do that in Windows Environment.

Something like.. In Unix..
tail 100 datafile.dat
head 200 datafile.dat
grep "findstring" datafile.dat

How are the above functionalities achieved in a Windows DB Environment in general?
|||

Something like.. In Unix..
tail 100 datafile.dat
head 200 datafile.dat
grep "findstring" datafile.dat

How are the above functionalities achieved in a Windows DB Environment in general?

I google for tail.exe head.exe and grep.exe and do it in the same method. The nice folks at unxutils.sourceforge.net have ported all your favorite unix utilities to DOS commands so that you can use them in Windows. We do like to try to make the transition from Unix to windows as painless as possible.

Oracle DBA to learn MS SQL

Is there a materials such as the following for an Oracle DBA who would
like to learn MS SQL(e.g. 2005)
- Training courses
- Web sites/ebooks
- MS articles
- etc
SQL Server features and compare it with Oracle.
So, it should be something of learning method for a person with DBA
knowledge(i.e. not for a beginner!)
cheers
Sandiyansandiyan@.yahoo.co.uk wrote:

> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
Try typing this into Google:
migrate oracle microsoft sql server
It yields many results, including this:
http://vyaskn.tripod.com/ oracle_sq...ent
s.htm|||Hi
Its really funny because I'm a SQL Server DBA is going to learn Oracle
:-))))))
Well, as for Oracle , there are lots of info about SQL Server as well
I'd start with www.microsoft.com\sql
http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
--administaiting best practices
http://vyaskn.tripod.com/sql_server...t_practices.htm --sec
urity
best practices
http://www.umachandar.com/resources.htm-- very good site , a lot of
examples
http://support.microsoft.com/direct...B;EN-US;Q224453>--
--
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
(Q224453)
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
http://support.microsoft.com/defaul...q246133--
How To Transfer Logins and Passwords Between SQL Servers (Q246133)
<sandiyan@.yahoo.co.uk> wrote in message
news:1155208415.129550.57030@.q16g2000cwq.googlegroups.com...
> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
> - Training courses
> - Web sites/ebooks
> - MS articles
> - etc
> SQL Server features and compare it with Oracle.
> So, it should be something of learning method for a person with DBA
> knowledge(i.e. not for a beginner!)
>
> cheers
> Sandiyan
>|||Check out Microsoft SQL Server 2000 for the Oracle Professional:
http://www.microsoft.com/sql/techin...os.mspx

Hope this helps.
Dan Guzman
SQL Server MVP
<sandiyan@.yahoo.co.uk> wrote in message
news:1155208415.129550.57030@.q16g2000cwq.googlegroups.com...
> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
> - Training courses
> - Web sites/ebooks
> - MS articles
> - etc
> SQL Server features and compare it with Oracle.
> So, it should be something of learning method for a person with DBA
> knowledge(i.e. not for a beginner!)
>
> cheers
> Sandiyan
>|||> Check out Microsoft SQL Server 2000 for the Oracle Professional:
> http://www.microsoft.com/sql/techin...racle-pros.mspx

That link was for Microsoft SQL Server 2005 for the Oracle Professional,
which is probably most relevant for your situation. If you are interested
in SQL 2000 too, that article is at the link below. There are enough
architectural differences in the SQL Server versions to warrant different
articles.
http://www.microsoft.com/technet/pr...y/sqlorpro.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Oe%23RVUHvGHA.3552@.TK2MSFTNGP03.phx.gbl...
> Check out Microsoft SQL Server 2000 for the Oracle Professional:
> http://www.microsoft.com/sql/techin...os.ms
px
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> <sandiyan@.yahoo.co.uk> wrote in message
> news:1155208415.129550.57030@.q16g2000cwq.googlegroups.com...
>|||SQL Server Books online will a very good startup for learning SQL Server
Thanks
Hari
SQL Server MVP
<sandiyan@.yahoo.co.uk> wrote in message
news:1155208415.129550.57030@.q16g2000cwq.googlegroups.com...
> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
> - Training courses
> - Web sites/ebooks
> - MS articles
> - etc
> SQL Server features and compare it with Oracle.
> So, it should be something of learning method for a person with DBA
> knowledge(i.e. not for a beginner!)
>
> cheers
> Sandiyan
>

Oracle DBA to learn MS SQL

Is there a materials such as the following for an Oracle DBA who would
like to learn MS SQL(e.g. 2005)
- Training courses
- Web sites/ebooks
- MS articles
- etc
SQL Server features and compare it with Oracle.
So, it should be something of learning method for a person with DBA
knowledge(i.e. not for a beginner!)
cheers
Sandiyansandiyan@.yahoo.co.uk wrote:
> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
Try typing this into Google:
migrate oracle microsoft sql server
It yields many results, including this:
http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm|||Hi
Its really funny because I'm a SQL Server DBA is going to learn Oracle
:-))))))
Well, as for Oracle , there are lots of info about SQL Server as well
I'd start with www.microsoft.com\sql
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1
--administaiting best practices
http://vyaskn.tripod.com/sql_server_security_best_practices.htm --security
best practices
http://www.umachandar.com/resources.htm-- very good site , a lot of
examples
http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q224071--
Moving SQL Server Databases to a New Location
<http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q224453>--
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
(Q224453)
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133--
How To Transfer Logins and Passwords Between SQL Servers (Q246133)
<sandiyan@.yahoo.co.uk> wrote in message
news:1155208415.129550.57030@.q16g2000cwq.googlegroups.com...
> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
> - Training courses
> - Web sites/ebooks
> - MS articles
> - etc
> SQL Server features and compare it with Oracle.
> So, it should be something of learning method for a person with DBA
> knowledge(i.e. not for a beginner!)
>
> cheers
> Sandiyan
>|||Check out Microsoft SQL Server 2000 for the Oracle Professional:
http://www.microsoft.com/sql/techinfo/whitepapers/sql-server-2005-oracle-pros.mspx
--
Hope this helps.
Dan Guzman
SQL Server MVP
<sandiyan@.yahoo.co.uk> wrote in message
news:1155208415.129550.57030@.q16g2000cwq.googlegroups.com...
> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
> - Training courses
> - Web sites/ebooks
> - MS articles
> - etc
> SQL Server features and compare it with Oracle.
> So, it should be something of learning method for a person with DBA
> knowledge(i.e. not for a beginner!)
>
> cheers
> Sandiyan
>|||> Check out Microsoft SQL Server 2000 for the Oracle Professional:
> http://www.microsoft.com/sql/techinfo/whitepapers/sql-server-2005-oracle-pros.mspx
That link was for Microsoft SQL Server 2005 for the Oracle Professional,
which is probably most relevant for your situation. If you are interested
in SQL 2000 too, that article is at the link below. There are enough
architectural differences in the SQL Server versions to warrant different
articles.
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorpro.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Oe%23RVUHvGHA.3552@.TK2MSFTNGP03.phx.gbl...
> Check out Microsoft SQL Server 2000 for the Oracle Professional:
> http://www.microsoft.com/sql/techinfo/whitepapers/sql-server-2005-oracle-pros.mspx
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> <sandiyan@.yahoo.co.uk> wrote in message
> news:1155208415.129550.57030@.q16g2000cwq.googlegroups.com...
>> Is there a materials such as the following for an Oracle DBA who would
>> like to learn MS SQL(e.g. 2005)
>> - Training courses
>> - Web sites/ebooks
>> - MS articles
>> - etc
>> SQL Server features and compare it with Oracle.
>> So, it should be something of learning method for a person with DBA
>> knowledge(i.e. not for a beginner!)
>>
>> cheers
>> Sandiyan
>|||SQL Server Books online will a very good startup for learning SQL Server
Thanks
Hari
SQL Server MVP
<sandiyan@.yahoo.co.uk> wrote in message
news:1155208415.129550.57030@.q16g2000cwq.googlegroups.com...
> Is there a materials such as the following for an Oracle DBA who would
> like to learn MS SQL(e.g. 2005)
> - Training courses
> - Web sites/ebooks
> - MS articles
> - etc
> SQL Server features and compare it with Oracle.
> So, it should be something of learning method for a person with DBA
> knowledge(i.e. not for a beginner!)
>
> cheers
> Sandiyan
>