Re: OSQL vs Enterprise Manager

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/13/04

  • Next message: Martijn Tonies: "ANN: Advanced Data Generator 1.2.0 released" 
    Date: Sun, 12 Sep 2004 23:01:08 -0500

    Hi,

    With OSQL you can do all the TSQL commands, but you have to type in your
    commands, where as in Enterprise manager you could do all the tasks by mouse
    click. I recommend you to use either Query analyzer or OSQL, this will
    increase your knowledge.

    FYI, We can not say any pros and cons...between both of them

    One disadvantage in Enterprise manager:

    If you add a column in a table, EM will unload the data , script the table,
    change it to new and load the data back. Where as OSQL .. ALTER Table
    command just
    adds the column directly into the table.

    Thanks
    Hari
    MCDBA

    "AW" <anonymous@discussions.microsoft.com> wrote in message
    news:0dd601c4993a$837d5b00$a501280a@phx.gbl...
    > Can I say that osql is a cmd-line utility of GUI
    > Enterprise Manager?
    >
    > Would you please list the Pros and Cons of them?
    >
    > Thanks!

  • Next message: Martijn Tonies: "ANN: Advanced Data Generator 1.2.0 released"

    Relevant Pages

    • Re: How do I create a new emkey for Enterprise Manager Database Control?
      ... How do I create a new emkey for Enterprise Manager Database Control? ... reinstalled the repository with these commands: ...
      (comp.databases.oracle.server)
    • How to Replicate using OSQL?
      ... I've installed a MSDE 2000 in a remote Computer. ... and set subscriber from OSQL? ... how can I use Enterprise Manager ... from another computer to configure Replication Scenario's ...
      (microsoft.public.sqlserver.msde)
    • RE: SQL Server Jobs
      ... > I have a SQL Server Agent job with multiple steps. ... > Operating System Commands that execute OSQL statements. ... > they were successful or not. ...
      (microsoft.public.sqlserver.programming)
    • Commands unavailable: SQLLOAD / IMP / EXP
      ... I managed to get round the problem by IMPorting my data in Enterprise Manager but now I really do need to use SQLLOAD and I am not sure what is causing the problem. ... I am trying to do this with a user who has DBA permissions and IMP/EXP permissions but maybe that isn't enough? ... All other commands seem to work fine with that configuration. ...
      (comp.databases.oracle.misc)
    • Re: getting ASPNET to work with MSDE
      ... > Since MSDE does not include the enterprise manager, ... > administration tasks to be performed are done so using OSQL. ...
      (microsoft.public.dotnet.framework.aspnet)