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 to SQL 2005 Replication

Greetings,
I am looking for a tool that i can use to replicate oracle tables into Sql
2005 database. Or if i can pull the data out of oracle using a sql tool that
would be perfect. The database tables are only 2GB or so. Can someone share
some insight on whether this is feasible or not.
Thanks In Advance
Deon
Transactional replication for Oracle Publishers (v 8.0.5 upwards) is built on
the Microsoft SQL Server transactional replication publishing architecture
for SQL 2005.
Pls have a look in BOL for more details.
Cheers,
Paul Ibison
|||Thanks Paul.
What is BOL?
"Paul Ibison" wrote:

> Transactional replication for Oracle Publishers (v 8.0.5 upwards) is built on
> the Microsoft SQL Server transactional replication publishing architecture
> for SQL 2005.
> Pls have a look in BOL for more details.
> Cheers,
> Paul Ibison

Oracle EM for SQL Server 2000?

Hi,
Can anyone suggest a tool that manages SQL server instances - other than SQL
Enterprise Manager? I'm thinking of an equivalent to Oracle Enterprise
Manager.
I need something that will give me a view of, and manage, 50+ SQL Server
instances.
Cheers,
James G.
http://www.aspfaq.com/show.asp?id=2442
David Portas
SQL Server MVP
|||Try
DBArtisan
u can get a tial version from the DBartisan website
search in google for the toolls
i do not remember the web site.
from
Doller
|||I believe you can also use OEM, just pay and install agent into sql server
PC.
Tell us how it looks if you try it.
"James Goodwill" <james.goodwill@.uk.fujitsu.com> wrote in message
news:8POZe.671$TL4.582@.newsfe4-win.ntli.net...
> Hi,
> Can anyone suggest a tool that manages SQL server instances - other than
> SQL
> Enterprise Manager? I'm thinking of an equivalent to Oracle Enterprise
> Manager.
> I need something that will give me a view of, and manage, 50+ SQL Server
> instances.
> Cheers,
> James G.
>

Oracle EM for SQL Server 2000?

Hi,
Can anyone suggest a tool that manages SQL server instances - other than SQL
Enterprise Manager? I'm thinking of an equivalent to Oracle Enterprise
Manager.
I need something that will give me a view of, and manage, 50+ SQL Server
instances.
Cheers,
James G.http://www.aspfaq.com/show.asp?id=2442
--
David Portas
SQL Server MVP
--|||Try
DBArtisan
u can get a tial version from the DBartisan website
search in google for the toolls
i do not remember the web site.
from
Doller|||I believe you can also use OEM, just pay and install agent into sql server
PC.
Tell us how it looks if you try it.
"James Goodwill" <james.goodwill@.uk.fujitsu.com> wrote in message
news:8POZe.671$TL4.582@.newsfe4-win.ntli.net...
> Hi,
> Can anyone suggest a tool that manages SQL server instances - other than
> SQL
> Enterprise Manager? I'm thinking of an equivalent to Oracle Enterprise
> Manager.
> I need something that will give me a view of, and manage, 50+ SQL Server
> instances.
> Cheers,
> James G.
>

Oracle EM for SQL Server 2000?

Hi,
Can anyone suggest a tool that manages SQL server instances - other than SQL
Enterprise Manager? I'm thinking of an equivalent to Oracle Enterprise
Manager.
I need something that will give me a view of, and manage, 50+ SQL Server
instances.
Cheers,
James G.http://www.aspfaq.com/show.asp?id=2442
David Portas
SQL Server MVP
--|||Try
DBArtisan
u can get a tial version from the DBartisan website
search in google for the toolls
i do not remember the web site.
from
Doller|||I believe you can also use OEM, just pay and install agent into sql server
PC.
Tell us how it looks if you try it.
"James Goodwill" <james.goodwill@.uk.fujitsu.com> wrote in message
news:8POZe.671$TL4.582@.newsfe4-win.ntli.net...
> Hi,
> Can anyone suggest a tool that manages SQL server instances - other than
> SQL
> Enterprise Manager? I'm thinking of an equivalent to Oracle Enterprise
> Manager.
> I need something that will give me a view of, and manage, 50+ SQL Server
> instances.
> Cheers,
> James G.
>