Re: How to use SQL Server Express

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks.

I had never heard of SQL Server Management Studio Express before - but there you go !

justin wrote:

As for a GUI, you probably want to download SQL Server Management
Studio Express. I think it can be used to SQL Server or SQL Server
Express. It's a free download from Microsoft, although it sometimes
takes a while to find on their download list.

As for your modifications, there shouldn't be many. Microsoft has a
few special tweaks to SQL but I think it's fairly similar. I do not
have experience with MySQL though, so I don't know. My suggestion is
to use Management Studio Express to create some sample SQL statements.
It will show you the SQL it creates. Take a look at it and see if you
can notice any differences.

Hope that helps.

On Feb 5, 10:14 am, Bit Byte <r...@xxxxxxxxxxx> wrote:

I just downloaded SQL Server Express (along with Visual Web Developer).
However I am at a loss as to how to use it - since it appears to have
installed only a service/server configurator (IIRC) - and there is no
available documentation (with the install).

I have a lot of experience with other RDBMs (Sybase, MySQL, Oracle and
PostgreSQL), so all I need is an interface (either command line or GUI),
so I can create a database and start writing test db schemas to test
with this db.

Questions are:

1). What interface is used to interact with SQL Server Express ?
2). I have an existing schema which uses MySQL dialect of SQL - what
modifications do I need to make to be able to create my db in SQL Server ?



.

Relevant Pages

  • Re: MS SQL Server Management Studio - Import and Export Settings
    ... I have already set the values in that registry key to reference my ... And the result was successful. ... if I delete it is re-created when I open Management Studio. ... Server will re-create this directory when we launch the SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: MS SQL Server Management Studio - Import and Export Settings
    ... Server will re-create this directory when we launch the SQL Server ... For more information, if we manually remove the whole "Shell" registry key, ... the SQL Server Management Studio. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Browser and Online book Questions
    ... The problem lies in the Management Studio Express tool released on November ... This update fixes the defect where installing the full Books Online ... Clear your browser's download cache. ... the Express BOL only contains topics that are specific to SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Management Studio Cannot Open SQL Express Files
    ... I suggest you to open SQL Server Configuration Manager and see how many SQL Server instances are installed and you can see what instance of SQL Server ... If I create the database in VS2005 using the ... If I create the DB in Management Studio I cannot work with it in VS2005. ... I cannot install the SQL Express Management Studio. ...
    (microsoft.public.sqlserver.tools)
  • Re: How can I remove Public access to SQL Express dbs?
    ... Will the SQL Server Management Studio work ... You can't delete guest but can render it unusable by revoking ... CONNECT permission in databases other than master and tempdb. ...
    (microsoft.public.sqlserver.security)