I just installed MSSQL 2005 Express but I can′t find a sql client I can use to create databases.
Do I have to download it or it′s placed somewhere on my HD?
The only tools I see are placed at Start > Programs > Microsoft SQL Serve 2005 > Configuration Tools
Sorry about the dump question. I come from a linux background and everything seems to be different!
Cheers.
The download for the Express Edition does not include a GUI tool for managing the database. We have posted a pre-release version of the free management GUI tool - Management Studio Express Edition on the web for download. You can get it at: http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en.
You can also download the documentation for Express at http://www.microsoft.com/downloads/details.aspx?FamilyID=9697aaaa-ad4b-416e-87a4-a8b154f92787&DisplayLang=en.
Out-of-the-box Express includes a command line tool SQLCMD for working with the installation (creating databases, creating tables, etc.) You can read more about it in the documentation.
Good luck.
Dan|||Hi Dan. Thanks for your quick reply!
In the meanwhile I downloaded the trial version (~900mb, outch!!).
How do I import ddl files into a database (trial version)?
Can I do it using theManagement Studio Express Edition too?
Cheers!
|||You can execute your sql script using SQLCMD.exe (from the command line) or using the Management Studio Express GUI.
No comments:
Post a Comment