2

Yeah I know that SQL Server has got free express editions(2005/2008)
But what i want is a small simple opensource tool like Heidi Sql.
What are my options?

Regards,
naveenj

P.S: This is for my fellow Java developer who admonished me for entertaining the idea that he would install MS-SQL in his machine(lol)

naveen
  • 53,448
  • 46
  • 161
  • 251
  • It's not clear what you want - do you want an open-source *dbms* or simply an open-source *front end* to MS SQL Server (and what would be the point of that?) – AakashM Jul 14 '10 at 10:49
  • 1
    see http://stackoverflow.com/questions/5170/sql-server-management-studio-alternatives for several suggestions – Ed Harper Jul 14 '10 at 10:55
  • @Akash > Please read the title "front end" – naveen Jul 14 '10 at 11:02
  • So you're going to run a *proprietary* DBMS, but you want an *open-source* front end to it? I'm not sure I understand what would be the reason for wanting such a thing. – AakashM Jul 14 '10 at 11:05
  • @Akash > My fellow developer and i am collaborating on a project spanning three four technologies. he just asked me is there a heidi sql like tool he can use to see data in the table. thats all – naveen Jul 14 '10 at 11:14
  • Just install the SQL Management Studio? Seriously, you should have more interesting things to spend your time on than creating problems for yourself. – JamesRyan Feb 03 '13 at 18:08

6 Answers6

4

HeidiSQL has built in support for Microsoft SQL Server since some weeks now in the latest builds. There are quite some important things left to do for me to implement to get it comparable to MySQL support, e.g. SQL export, table structure editing and the user manager which are all full of MySQL specifics. But at least you can browse SQL Server table data, see table columns and data types, and fire queries.

Anse
  • 41
  • 2
1

If you want a front-end, have you tried SQuirreL?

João Pereira
  • 3,545
  • 7
  • 44
  • 53
1

The lightest-weight query tool I know of is QueryExPlus

Ed Harper
  • 21,127
  • 4
  • 54
  • 80
  • thanks ed. i liked it. suits me perfectly. supposedly made in .NET(Joseph Albahari). very light(172 kb)... glad i asked. time to pull the leg of my java guy :) – naveen Jul 14 '10 at 11:23
0

I have find it from 2005 to 2011....Still no free or open-source is good to use. MS Management studio express is enought to use, but it is too heavy on memory.

Cheung
  • 15,293
  • 19
  • 63
  • 93
0

I recently introduced MS SQL support in HeidiSQL. There are a lot dialogs and stuff which is still MySQL related and does not work for MS SQL, but you can browse tables and data, and fire queries.

Anse
  • 41
  • 2
0

I have use a tool called Query Express before and it works great. Also it is a light weight application.

Mark Kram
  • 5,672
  • 7
  • 51
  • 70