A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [sql-server]

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

68 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
0answers
9 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 ...
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 ...
0
votes
0answers
8 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 ...
0
votes
0answers
6 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
5 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
24 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 ...
0
votes
0answers
13 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 ...
0
votes
1answer
32 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
7 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
12 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 ...
0
votes
1answer
47 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 ...
0
votes
0answers
28 views

Scheduling Jobs - Software Development

I require a free tool (capable to be mantain or grow up with my own developments) to maintain, monitor and schedule cron jobs that run on Windows, Linux, and executes MSSQL SSIS and MSSQL commands. ...
0
votes
2answers
61 views

Tool to write a scheduled job that sends an email every 5 minutes using .Net core & SQL Server

My requirement is to write a batch program/job that sends an email every 5 minutes. It will query an sql server database. My team is a microsoft shop so we are exposed to .Net core and SQL server. ...
-1
votes
1answer
21 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 ...