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
No comments:
Post a Comment