question

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 asked SOEDIBJOAndy-4689 answered

Free Web User Interface to uodate sql tables

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I have no idea what you mean by "master depth" but I assume that you mean that you want a GUI (application) which show the table data in a grid and provide option to edit he data using the GUI.

If this is your need then:

If you are using Azure Database, then there is a new tool in the portal which is in preview. It named: Azure portal's query editor

https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-query-portal

Use it on your own responsibility as it is still in preview

It allows you to view the table data in grid and edit the data in the grid

Go to the Portal -> go the database -> on the left menu click on "query editor (preview)"

126959-image.png

The editor will opened -> find the table which you want to edit the data -> right click the table -> Select: Edit Data (preview)

126966-image.png

click on the value which you want to edit and edit it

If you are using On-premises SQL Server then there are multiple third party applications. Please clarify if you want to use the browser or a desktop app



0 Votes 0 ·
image.png (3.0 KiB)
image.png (17.9 KiB)
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @IsmailCassiem-3967,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

pituach avatar image
0 Votes"
pituach answered pituach edited

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://docs.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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IsmailCassiem-3967 avatar image
0 Votes"
IsmailCassiem-3967 answered

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SOEDIBJOAndy-4689 avatar image
0 Votes"
SOEDIBJOAndy-4689 answered

Hi Ismail,

Just wondering if you have found an appropriate solution for your need?
Recently i have similar need to provide a simple web UI for database table view in grid/excel format - but to offer the possibility for user to update incorrect data - by adding audit logs of what has been updated & comments.

Any suggestions are really appreciated.

Thanks.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.