Questions tagged [sql-server]
Use this tag specifically when seeking recommendations relating to Microsoft SQL Server. For general database questions use the [database] tag.
111
questions
15
votes
1answer
1k views
Replacement for MS Access, very rapid development
Background: I have an Access-software (~30 simultaneous users) with split front- & back-end, both UI & DB running on Access-files. Most important features for me are reports & printing, ...
9
votes
6answers
9k views
Web-based OLAP CUBE browser?
I have cube on MS SQL Server and I want to install a web based visual client tool for exploring and analyzing OLAP databases.
A cube is an array of data understood in terms of its 0 or more dimensions....
8
votes
1answer
248 views
Software library or tool to pivot and export a lot of data to Excel
I'm trying to find a way to get normalized data that's in an MSSQL database out of there, pivoted, and into an Excel file. The main problem is that I have many of those databases, each with the same ...
8
votes
1answer
494 views
.NET/MSSQL forum software supporting 3+ million users
This is not a duplicate of Forum solution for ASP.NET MVC Application.
I've been searching for a (preferable) MVC.NET Forum Solution with the following requirements and found 2 "worth looking at" ...
5
votes
2answers
5k views
Complex SQL Query visualizer
Is there a tool (gratis), that helps developer to understand or helps to visualize the complex queries (involving JOINS, GROUP BY).
I know about the snowflakesjoins service which provides visualizer ...
5
votes
3answers
5k views
SQL Server client for Ubuntu
I need to connect to a MS SQL Server database from my Ubuntu machine. Any client suggested? I found libmono-entityframework-sqlserver6.0-cil, will that work?
It doesn't sound like just a client:
...
5
votes
1answer
149 views
SQL Server database version control
I'm looking for open source SQL Server database version control addon/tools to link with Git.
I tried gitSQL and red-gate sql source control (not an open source). With gitSQL I see a problem that ...
5
votes
1answer
1k views
SQL server and client for Ubuntu (Debian) [closed]
I have been using MS IIS server and MS Sql client Management Studio at workplace on Windows system. My home system is a Ubuntu system and I like setup a database server and a client to interact with ...
4
votes
1answer
73 views
Database technology recomendation for simulator
Alright so I am developing a simulation application and I need to know what database is advisable (Or the pro's con's of some options).
tl;dr:
C# application
Only the application will be using it
...
3
votes
2answers
365 views
Database schema visualization for MS SQL Server
Are there any tools for schema visualization of an existing MS SQL Server database? In particular, I'd like something that reads the tables, fields, and constraints automatically, and that allows for ...
3
votes
2answers
162 views
Tool to generate SQL database update scripts
I'm looking for a tool or an open-source project that can generate database update scripts in the following way:
Accept a database connection string as a config parameter
Connect to the specified DB ...
3
votes
3answers
17k views
What is the best frontend program for my database needs?
I am currently an Electrical engineer and I have been tasked to set up a database(outside my realm of expertise) that will be used by multiple users over a networked drive. There will only be a couple ...
3
votes
1answer
116 views
Free SQL test data generator
I'm searching for a tool to generate SQL test data.
What I'm looking for exactly should
Be gratis
Generate test data from Regex
Be compatible with Microsoft SQL Server (compatibility with MySQL and ...
3
votes
2answers
93 views
Access to SQL-database, SQL-rapporting
I am looking for software that allows non-sql users to access an SQL-database, and set up data exports fast and easy.
Background:
My company has a lot of data in our SQL-database. We do not have ...
3
votes
0answers
35 views
Excel to SQL mapping tool
I am looking for a tool/library to import data from different clients into our SQL database. Each client will have their own EXCEL file. So the number of columns, name of the columns in EXCEL would be ...
3
votes
2answers
88 views
Looking for CMS/Wiki for IIS/SQL Server platform
We are SaaS company and looking to update our web help portal. We can host ourselves, but prefer this to be more Microsoft-ish (SQL Server, IIS)
Currently we use Confluence, here is what we like:
...
3
votes
0answers
75 views
PHP Ad Manager (free)
I'm working with a PHP website that uses a custom CMS based on a MSSQL database.
I'm desperately looking for a solution to install an Ad Manager, and I don't have much time so I would like to know ...
2
votes
3answers
126 views
RDBMS for newbies in IT
I need to teach my two interns how to use RDBMSes in general and "standard" SQL during their free time, using the outdated windows notebooks we have laying around. They come from math courses and have ...
2
votes
3answers
68 views
Which software can I use to browse a MSSQL database?
I want something similar to phpMyAdmin for an MSSQL server.
It MUST have / be:
M1: a graphical interface where I can see all table names
M2: gratis
M3: work with ubuntu 16.04
Nice to have would be
...
2
votes
2answers
67 views
Tool for deploying web-project to the server
I don't need a recommendation, but need a tool name or, at least, a name of such tools (probably, language barrier).
I am looking for a tool which will help me to deploy a project to the server.
...
2
votes
1answer
40 views
PHP MSSQL Table editor in browser
I have a website running PHP, and a Microsoft SQL Database at the back end.
I want an end user to be able to edit a table within the SQL database.
I want them to be able to do this using a page on the ...
2
votes
1answer
67 views
SQL Server replication tool
I'm looking for a Windows tool (preferably installable as a windows service) for periodic database synchronization.
Once every X minutes it should connect to Source SQL Server database, check for any ...
2
votes
2answers
62 views
Best tool for browsing schema or database properties or tabls structure of remotely installed Microsoft SQL Server by PHP
I'm seeking a tool to browse Microsoft SQL database server in PHP like phpMyAdmin. Is there any open source known project that works with Remote Microsoft SQL Server?
I found some php open source ...
2
votes
1answer
72 views
Geo Mapping tied to an SQL Database
First a little background on this project.
Our company has developed a web page for our Inside Sales team that lets them enter a Zip Code and it returns the District Manager that is responsible in ...
2
votes
0answers
6 views
NoSQL or RDBMS for user defined columns
We will soon be rewriting an application that will allow the end user to define objects and fields on those objects.
I come from an MSSQL background and am familiar with options to handle this use ...
2
votes
0answers
94 views
Azure SQL Server client for Mac OS X that does not require Java
Is there a Microsoft SQL Server client that runs on Mac OS that does not require Java? If there is more than one, which would you recommend?
Besides one that runs the usual queries, I would also like ...
2
votes
0answers
149 views
Machine Learning Multiclass Classification for thousands of Classes
I have Entities with 1 to 10 attributes describing each of them and I need Machine Learning to suggest best matching Class for each Entity. Sounds straightforward, but there are about one hundred ...
2
votes
3answers
3k views
Reporting tool/framework/library for .Net
I want to print pdf reports with lots of charts and text on demand. I have some sub reports, which can be generated stand-alone and can also be merged to generate a single master report.
Right now, ...
1
vote
1answer
19 views
Software to build networks visualization using relational tables
I've an table in SQL Server with the following schema:
- Partner_ID
- Child_ID
- Relationship_Name
Example of my data:
Partner_ID Child_ID Relationship_Name
A A1 ...
1
vote
1answer
69 views
Which Software to take, when creating a database diagram
We are using a MS SQL Server database and we want to create a database diagram for an existing database.
There were several options on how to do this: In Microsoft Visio 2010, Visual Studio 2013 or ...
1
vote
1answer
132 views
Recommendations for creating wallboard-type displays using MSSQL data sources
I'm looking for some recommendations in terms of data visualisation tools.
At my current place of work we have 'Wallboards' - these are basically web pages which are displayed on the big screens, ...
1
vote
2answers
170 views
Which tool to use for SQL Server Database migrations and why as of 2017?
I want to know a tool to use for SQL Server Database migrations and why as of 2017, since I worry about this topic, so I can automate this process as much as possible.
What do you think about Entity ...
1
vote
1answer
98 views
Experience with database repair tools for mdf files?
I've got a HDD which is encrypted with petya-green. I used "Disk Internals NTFS Recovery" for recovering the databasefiles which are needed.
Than I tried to simpl attach the databasefiles to a new ...
1
vote
1answer
62 views
SQL Data verification framework?
I receive a variety of flat files that need to be transformed and aggregated in several stages of a custom ETL process before loading it into a SQL Server database.
After each stage, I'd like to ...
1
vote
2answers
26 views
What software do I use to process year by year calculations for large datasets?
I'm trying to move my .NET program to a database engine but I'm having trouble finding what specific platforms/languages I'm supposed to use. Right now everything is done on the client-side ...
1
vote
1answer
100 views
Automatic synchronization tool for MS SQL Server
I am looking for a specific tool which should automatically syncronizes the data between two databases present on two different servers. Whatever gets updates or inserted on the database on 1st server ...
1
vote
0answers
20 views
Best Tool for Analyzing Multi-Tab Excel Files with 100-500k Records
I have started a new job and I need to analyze client's databases. Many times when we first meet with them we just get a huge Excel file with a dozen or so tabs and a partial to full dump of various ...
1
vote
0answers
7 views
I am trying to get a list of zipcodes which are duplicates in more than two states and the query below is throwing a syntax error [closed]
select ZIP, count(distinct STATE) COUNT , STATE from DATA_TBL
group by ZIP, STATE having count > 1;
1
vote
0answers
7 views
Are there any open source API's to push and pull data tables from SQL to Google Cloud(Big Query) and Vice Versa?
Part of my jobs is to push and pull data tables from SQL to the Google cloud (Big Query) and vice versa. I was wondering if there are any robust API's that can be used in my web apps, SSIS Packages, ...
1
vote
0answers
12 views
Converting SSN to alternate 9 digits [closed]
Looking for some idea or an algorithm to convert a 9 digit SSN to an alternate 9 digit id. This is to protect the SSN of individuals. I would prefer to be able to convert back the alternate 9 digits ...
1
vote
1answer
7 views
How can I install a small/lite version of SQL server on my client's machine for my software trial version?
I'm a software engineer and I'm currently working on a new project. My clients always complain about my trial versions as it takes too much time and resources. I usually install SQL server full ...
1
vote
0answers
4 views
Tool to convert stored procedures from SQL Server to MySQL
I am already tried like a below tools for conversion
Mysql workbench
Dataloader (trial version)
DRPU database converter (trial version)
But, still i can't able to convert Stored procedures from sql ...
1
vote
0answers
20 views
Software/tool to design database diagrams for MSSQL
I am looking for a free software/tool to design database diagrams for MSSQL. There are some online tools which I think great but not free
https://sqldbm.com
https://app.quickdatabasediagrams.com/
...
1
vote
0answers
18 views
Tool for monitoring table churn in MS SQL Server
I am looking for Desktop or Web based MS SQL Server monitoring tools, that runs on Windows Server 2008 ~ 2012, my budget is around $3000, who have this capability:
Able to monitor how many data rows ...
1
vote
0answers
30 views
R access to SQL Server
I'm having to update my access to SQL Server from R on windows. The only option I see right now is odbc. Unfortunately, the ODBC standard and this driver (using nanodbc) in particular has some ...
1
vote
0answers
24 views
Tool for transferring data from linux machine to MSSQL on remote (Windows) machine
Is there some kind of opensource / free tools for transferring data from a linux machine to a remote (Windows Server 2012) MSSQL Database Server that can be called / controlled via a bash script? ...
1
vote
0answers
11 views
Some freeware tool or script to fetch the MS SQL Server Edition
I need to check "Microsoft SQL Server Edition" e.g. Standard, Express or Enterprise etc installed on multiple systems, but to get the edition details I manually execute @@version query on each SQL ...
1
vote
0answers
21 views
Mssql vs mysql for software development [closed]
Me and my team are developing a database software.We came a long way working with ms sql server.The project we are working on is also based on MsSql.Now , after we're done with the software , we'll ...
1
vote
0answers
29 views
Recommendation for a SQL server development and management tool
I am currently using Toad for SQL server 6.8 and I am very disappointed in the quality of the software. It took them more than year to deliver version 6.8 and finally, when they did, it is pretty much ...
1
vote
0answers
43 views
Generate ETL for many (173) delimited database files
I get a zip of 173 database files, in a delimited format, each day. We call this extract DbUnload. The company that sends me this file, won't adjust the file spec or give me notification of any ...
