Questions tagged [sql-server]

Use this tag specifically when seeking recommendations relating to Microsoft SQL Server. For general database questions use the [database] tag.

Filter by
Sorted by
Tagged with
0
votes
0answers
4 views

How robust is RedGate SQL Provision? [on hold]

My company has about 8 TB worth of "Production" SQL Server 2016 databases (7 differrent databases total) that we would like to be able to restore to lower environments. At the same time we have HIPAA ...
-1
votes
0answers
5 views

connect Microsoft SSMS 18 [on hold]

can I connect Microsoft SQL Server Management Studio to a server without having any other software? I installed SSMS 18 from microsoft official site.. but I couldn't connect to a server,I checked ...
-2
votes
0answers
3 views

WordPress and SQL Server

I'm looking to build an information system using SQL Server as the database. I'm familiar with MS Visual Studio to develop the interface that runs queries from the SQL Database. Does WordPress have ...
-1
votes
0answers
9 views

Two-way synchronization between MySQL and MSSQL [on hold]

I'm looking for two-way synchronization between MySQL and MSSQL (Azure) databases. At the beginning I wanted to create second MSSQL database, migrate first one and use Azure's two MSSQL DBs ...
-2
votes
0answers
7 views

How to merge sqlserver database with c# desktop application?

I've created a c# desktop application with SQL server database. Now the client wants me to merge that database with the project so that he won't have to install sqlserver in his computer. He said that ...
0
votes
0answers
6 views

Can I use Azure SQL Databese to learn, test and use smal programs, as a private person?

I would like to have an SQL server to test my small programs written in C# (usually 5-6 tables) uses MSSQL Databases. Azure and its SQL service seems to good for me but I'm not a company, only a ...
0
votes
0answers
4 views

Synch Data to and From Android device using SQLite db to MS-SQL db

I have an android app which makes use of a local sqlite db. We have developed our own code to synch data between the sqlite db and a cloud based sql standard/express db... the only problem is our ...
0
votes
0answers
4 views

MSSQL Server cluster to MSSQL always on

my on premise MSSQL using windows server cluster and shared storage. I want to create DR at the cloud. In my cloud, i can only use MSSQL always on. Is it possible to replicate my on-premise SQL to ...
0
votes
1answer
14 views

Is there a tool to view entity relations from a sql script?

I have a sql file with a long list of create tables and alter tables. Is there a tool available to look at the entity relationships that result from running the sql script. It would be great to not ...
0
votes
0answers
6 views

SSIS Excel (.xlsx) Connector to SQL Server 2012/2016 recommendations?

Any recommendations on 3rd party Excel Source/Destination Connectors for SSIS to SQL Server 2012/16? What are the kinks? I really can't find reviews on these things anywhere. We need something ...
0
votes
0answers
5 views

Which Azure PaaS SQL DB type for Data Warehouse (Single DB or Managed Instance)

I am considering a generic Data warehouse setup using Azure SQL DB. Which option would be best: Single Database OR Managed Instance The following differences I am already aware of that are key ...
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
votes
1answer
20 views

SSRS - SQL Server Reporting Services Possibility?

Currently, we have SQL Server 2012 R2. Looking to produce some reports and have them automatically run and have converted to PDF with the possibility of automating an email to send to subscribers of ...
0
votes
0answers
3 views

how to sync database from MS SQL to PostgreSQL

I have to do database sync from MS SQL to PostgreSQL. Intially i thought to do transact replication but MS SQL is not supporting Postgresql while creating Non SQL subscriber in subcriptions. Any ...
-2
votes
0answers
9 views

sql server enterprise edition 2014

I tried finding SQL Server Enterprise edition 2014 on internet but like Express editions it is not available readily. Can anyone provide the sql server 2014 enterprise edition download link?
0
votes
0answers
6 views

SQL Server 2017 to Mongo DB

I have SQL Server 2017 DB for my application. The data stored is already in JSON format. Now management has decided to move to MongoDB. 1) Could you please recommend a good ETL or Migration Tool to ...
1
vote
0answers
6 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
votes
0answers
11 views

How can I achieve database versioning in Azure SQL where users can build and share their own scenarios?

I am working on a project where we have built the solution in Azure, we store our data in AzureSQL. Now we have a new requirement where 3 different users from 3 different departments would like to ...
0
votes
0answers
5 views

Change Data Capture tools that work based on change logs in RDBMS

I am looking for a CDC-Change Data Capture tool that can capture change based on change log from an RDBMS. I am trying to do a CDC between databases DB2 and mssql. I know few tools that does this such ...
0
votes
0answers
4 views

AWS service to display data from database or configuration file

I need to display some data from a database or from a configuration file using AWS, Please suggest which AWS service is better to display data which is fetched from an ini or json file or from a ...
0
votes
1answer
17 views

Report distribution tool

we are looking for a SW/tool which would help us to automate the reports distribution. We use MS SQL Server 2016 and SSRS (Sql server Reporting Services), we have a knowledge of SQL coding. Our ...
1
vote
0answers
11 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 ...
0
votes
0answers
11 views

How to auto generate MSSQL database diagram, suitable for print on plotter

I am trying to find some software that can help me get our database scheme printed out in a big format. We have a DB with roughly 60-70 tables, and a lot of relationships between them. Overall i ...
0
votes
0answers
2 views

SQL Server Snapshot Alternative (Multiple per database)

I'm looking for a tool, either a built-in SQL Server feature or a third party tool, to do everything a database snapshot can do, plus having the ability to revert to more than one. Specifically, it ...
-2
votes
1answer
16 views

What software should i use to create a ERP SYSTEM?

i would like you help me with this question. if you have to make a software ERP , with modules like Human Resource, Inventory, Sales & Marketing, Purches, Finance & Accounting, Customer ...
0
votes
1answer
16 views

Dynamic web application based on MS Access

I am given MS Access file, based on which I need to create a web application with some statistics. The end user is downloading this MS Access file from some third party application, say once a week. ...
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 ...
0
votes
1answer
29 views

Need a database for a single-user app to sync data across computers without storing on the internet

Need suggestions for a database. I'm tasked to write a C# desktop application for a small business. The business owner does not want his data to be stored on the internet. He has two desktop computers....
0
votes
0answers
6 views

How to control/monitor BigQuery ETL process with Azure services

I'm looking for the best Service solution which would be able to trigger/monitor and control ETL process in BigQuery, then transfer files to Azure VM and do insert into MS SQL. Was trying to use ...
0
votes
0answers
12 views

Program for Windows users to add, update, delete, search SQL Server tables?

I'm creating a SQL Server database for our lost & found items. One table will have an inventory of lost items and another table will have inquiry information of those looking for items. Intuitive ...
0
votes
0answers
3 views

Comparing Tool for MS Reporting Services Objects

I have three MS Reporting Services Instances (Server), all in version of MS SQL-Server 2017. All instances have the same tree structure with hundreds of objects (datasources, datasets and reports) ...
0
votes
0answers
11 views

Transfering data from aurora to sql server

I am using auorora postgres database and sql server. Can you recommend a way how to transfer 100M rows table from aurora to ms server? I was trying to use spark for this issue and as I understood ...
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 ...
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/ ...
0
votes
1answer
19 views

Are there any main differences between MySQL (MariaDB), PostgreSQL, Oracle, Microsoft Databases for usage in enterprise? [closed]

Lets take this: Company using Microsoft Server Database since 2008. Its company what heavily depends on working with data from databases. (Construction company ) Current database is outdated and not ...
0
votes
0answers
98 views

Looking for a free, opensource, C#/.NET based URL-Shortener

I'm looking for a opensource URL-shortener which I can host myself which works with C#/.NET and a MSSQL database. There are quite a few free URL-shortener out there, but I'd like to shorten the URLs ...
1
vote
0answers
17 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
28 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
20 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? ...
0
votes
0answers
138 views

Free SQL Server Documentation Tools ?

I'm working on a large SQL Server database with no documentation,Are there any(opensource) documentation tools which supports SQL server 2016.I'm specifically looking in into the following. Document ...
0
votes
0answers
13 views

BitTorrent tracker software for Windows/SQL Server

Yes, I know there's a WIKI comparing tracker software. It's far from comprehensive and nothing on that page is relative. What I want to do is run a BitTorrent tracker on a small scale, probably no ...
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 ...
2
votes
1answer
39 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 ...
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
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
66 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
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 ...
0
votes
1answer
45 views

Which Software Solution should I Use to employ predictive analytics (as a newbie)?

I'm a Business Intelligence analyst working almost entirely with SQL Server Management Studio (SSMS) and Tableau to produce BI reports. I'd like to start to incorporate some predictive analytics, and ...
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 ...