Free Web User Interface to uodate sql tables

Ismail Cassiem 226 Reputation points
2021-08-26T16:43:11.193+00:00

Hi,

I need master depth to maintain some master attributes of a table in sql Dara warehouse

I tried some web tser interface, unfortunately all are licensed software which I don't have Capex

Please help, anything I can use , free tool with sql14 or sql19

Regards

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,488 questions
{count} votes

6 answers

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,426 Reputation points
    2021-08-27T02:42:19.387+00:00

    Hi @Ismail Cassiem ,

    What is your environment? I want to confirm with you that you are using Azure sql. If so, I will add a tag for you.

    Best regards,
    Seeya

    0 comments No comments

  2. Ismail Cassiem 226 Reputation points
    2021-08-27T12:50:26.957+00:00

    Hi,
    Thank You for assisting.
    DB SQL14 with ssis, ssas, ssas tabular, PBI Gateway

    Cant go Azure, parent company does not want to purchase license.

    I thought of installing MDS that has web gui, for users on the domain but anything neat will be great as users sharing domain could access

    please help, thank you

    0 comments No comments

  3. Seeya Xi-MSFT 16,426 Reputation points
    2021-08-30T10:03:18.343+00:00
    0 comments No comments

  4. Ronen Ariely 15,081 Reputation points
    2021-09-09T05:24:47.017+00:00

    Hello,

    DB SQL14 with ssis, ssas, ssas tabular, PBI Gateway

    You mention that you have "DB SQL14". I assume that by "DB SQL14" you mean that you work with "SQL Server 2014" which is an on-premises server.

    May I ask, why do you need "Web User Interface" ?

    Your users do not need to install anything in order to connect and manage SQL Server. Instead of using SQL Server Management Studio, you can use Microsoft Azure Data Studio which is an open source application, free, has version for all common operating system like Linux, mac and windows, and it does not require any installation. You can run it directly from external disk like Disk-On-Key

    https://learn.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15

    Download the .zip or the .tar.gz version for running without installation

    If this does not fit you, then please clarify why

    0 comments No comments

  5. Ismail Cassiem 226 Reputation points
    2021-09-09T06:13:03.927+00:00

    Hi,
    Thank you for assisting, really running out 9f time to implement.
    Correct it's sql server on prem 2014, the issue I'm trying to do is to somehow replicate an windows app to edit a sql table with drop downs.
    I can't write an app and share to semi internal users different company has access to domain, though there was a free web tool I could allow and share with external users to edit a specific sql table
    Thinking of excel with scripts in the background and security locked to edit a table that slows drop-down
    Please help?

    0 comments No comments