Which SQL Front End???

  • Morning all,

    I was wondering what front ends people are using?

    I'm aware that I can use MS Access but would prefer to use a web based front end, does this mean that I need to brush up on my Java :-)?

    Cheers, M


    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: http://markallen.co.uk/
    Business Website: https://www.weekendwebdesign.co.uk

  • All our user front ends are done in ASP.NET 4, but as long as you can code a connection string to SQL in the application, then you can pretty much use whatever coding language you want.

  • We have a mixture here of .NET 2 / 3.5 and 4, as well as MS Access. All works fine.

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • Do you mean a front-end to manage the SQL Server itself or an application front-end that uses SQL Server as the database?

    If the latter, we use mostly .net 4.0 using vb.net and c#. The former would be SSMS exclusively.

    Mark

  • There are several other products out there some use instead of SSMS. TOAD for SQL Server is one, and I know there are a few others even if I don't remember the names of the products.

  • At this current position we use SSMS mostly, though some of the developers use SQuirreL for query design etc.. The application itself is written in java using hibernate.

  • Mark Eckeard (8/8/2012)


    Do you mean a front-end to manage the SQL Server itself or an application front-end that uses SQL Server as the database?

    If the latter, we use mostly .net 4.0 using vb.net and c#. The former would be SSMS exclusively.

    Mark

    Cheers Mark, I use SSMS to manage SQL directly, I was thinking more along the lines of an easy to use (preferably muppet proof 😉 ) front end app for Jo Schmo to use to input data.


    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: http://markallen.co.uk/
    Business Website: https://www.weekendwebdesign.co.uk

  • Check out Microsoft Lightswitch. It's great for creating a basic CRUD front end application (web or fat-client).

    Just point it to a database and off it goes - I created a front end to a system in about 5 minutes. It understands constraints and data types even to the point of placing pop up calenders where it encounters a date field.

    http://www.microsoft.com/visualstudio/en-us/lightswitch</url]

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply