data-tools | File format conversion tools | Command Line Interface library

When I try to gem install red-arrow -v 3.0.0 in docker image based on LinuxKit with 'rails', '~> 6.0.3', I get the following error:

I have a grid created using a React library that I want to fill with data with an API call once the user clicks on a button called Fetch Products. Currently, my grid does not get populated and I get this error when I debug it:

I want to create a SQL Database project and manage my database as code (e.g. DevOps), but I am not sure what tools I can use for free within an enterprise.

How do I install and use SSDT without requiring paid licensing and violating any EULAs, such as Visual Studio Community Edition's?

In enterprise organizations (meaning those with >250 PCs or > $1M in annual revenue) no use is permitted...

This Microsoft article states that I can use SSDT in VS2019, but it doesn't tell me how to install it and not violate EULA.

This SSDT Download page is unhelpful and does not provide anything about licensing.

Also, I considered other tools, but looking at docs they don't seem comparable to SSDT:

• Azure Data Studio - (cross-platform) new preview extension SQL Database Project supports DACPAC. I wasn't happy with my previous trial of this product. Maybe I'll give it another try in a couple years.
• VS Code: Does not appear to have any extensions that directly support a SQL Database Project and/or DACPAC

Having completed the following tutorial: https://docs.microsoft.com/en-us/visualstudio/data-tools/walkthrough-creating-an-n-tier-data-application?view=vs-2019

I'm trying to make the same tutorial work with WPF instead of Windows Forms but can't for the life of me get it to display the database data in the Datagrid. My code for everything except the PresentationTier is the same (but with my own database data). My .xaml code is (largely default from dragging the table from the Data Sources tab):

So I've been working with SSDT unit tests for years, and one of my biggest bug-bears was how you could only have one configuration for the test project. If you wanted to run it against a different connection, you had to update the configuration file.

Today I stumbled across this blog post which suggests that actually, you can create machinename.sqlunittest.config files which override the config file : http://dataidol.com/jamesduggan/2015/09/05/2559/.

This is also mentioned on the Microsoft documentation here (although here it says machinename.sqlunitttest.config) : https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-data-tools/jj851202(v=vs.103)

This was a very exciting discovery, but I've spent all afternoon trying to implement it for one of our existing unit test projects which was created in VS 2015, and nothing seems to work; it never picks up the override file, it just uses the config file which gets generated from app.config.

I can't find any other references to this method of overriding the configuration, and these only refer to VS 2010, VS 2012 and VS 2013.

So what I want to know is, has anyone actually implemented this in VS 2015, and if so, did they have to do anything different to what is documented in those links?

I am trying make an paint app using ES6. But i am not getting proper position and line in canvas.

This line is not drawn in correct position, like top-left is formed when i click and from 0,0 corner of canvas.

As you can see Line is not starting from the point Cursor is pointing and this difference increases as we move from TOP-LEFT cornor to BOTTOM-RIGHT cornor.

I'm working on a small project for my studies. It's the first contact with SQL in Visual Studio 2019 Community Edition for me.

My study documents say that I can drag a table from the data sources window onto a form and a DataGridView would appear. That doesn't work. So I changed the property of the table from DataGridView to Details.

According to the documents from my university it should now add a TextBox with a Label for every row in the table.

Guess what? That won't work either. The cursor changes to the "Drop here" symbol, but if I drop the element onto the form nothing happens.

There is no error message or something like that.

Here's a pic of the cursor. Looks good for me. I'm connected to the db as well. It's a database file on my computer, so there can't be connectivity problems.

Google and the microsoft docs didn't help me with that.

Maybe someone else can? :)

We have a Visual Studio Database Project that we are trying to move to Azure SQL Database. Some of our views use AT TIME ZONE which is supported in Azure SQL Database, but when I switch the database Target Platform to Microsoft Azure SQL Database in the project properties, it fails to build with error:

Error: SQL46010: Incorrect syntax near TIME.

I have connected directly to the database in Azure and I can use AT TIME ZONE, but I cannot create or publish a DACPAC file from my project.

This SO answer suggests switching the target to SQL Server 2016, but then you cannot deploy the DACPAC to Azure. It will give the error

A project which specifies SQL Server 2016 as the target platform cannot be published to Microsoft Azure SQL Database v12.

when publishing from Visual Studio or the command line with sqlpackage.exe. (Same with all targets).

This seems like a long-standing bug in Visual Studio Data Tools so others must have run into it. Does anyone have a workaround or suggestions?