Stack Overflow
Stack Overflow

Questions tagged [azure-managed-database]

36 questions
0
votes
0 answers

How to connect/Load data to a SQL database inside the Azure Managed Instance via SSIS

I can successfully connect my "Azure managed instance" in my local SSMS. But not sure how to load data into the database via SSIS. Is there any supporting component to use for loading data into Azure managed instance from ON-Perm SSIS packages. Note…
Gowtham Ramamoorthy
  • 896
  • 4
  • 15
  • 36
0
votes
1 answer

Index creation time is high on Azure Managed Instance

I am working with Azure Managed Instances for hosting a data warehouse. For the large table loads the indexes are removed and rebuilt instead of inserting with the indexes in place. The indexes are re-created using a stored procedure that builds…
Dave
  • 61
  • 6
0
votes
1 answer

Azure SQL Managed Instance: RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

I'm trying to restore my database into Azure SQL Managed instance from blob storage URL. But I'm getting below error. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201) I tried to restore it to localhost and that…
Sandesh A D
  • 162
  • 2
  • 12
0
votes
1 answer

SQL Server - EXECUTE permission

In our Azure Managed Instance DB, a new user has been created and given db_datareader, db_datawritter and db_ddladmin. As per MS Documentation, db_ddladmin has CREATE PROCEDURE and ALTER ANY SCHEMA. But when logged in, I am unable to EXECUTE SPs and…
Iniyavan
  • 61
  • 1
  • 5
0
votes
1 answer

Azure SQL MI: The requested server principal already exists on Managed Instance

In my SQL MI i have a ad group (called Group A) which was already assigned to the Active Directory Admin through Portal. I'm trying to update/replace that with a new group called Group B. When I tried I get the error…
Jayendran
  • 9,638
  • 8
  • 60
  • 103
0
votes
1 answer

Associate static FQDN with Azure Managed Instance

I have a Azure managed instance that has a host name as yourdb..database.windows.net . I Whenever this managed instance is newly created I have to update this host name in every connection string. Is there a way which allows to have a…
S.Ali
  • 29
  • 4
0
votes
1 answer

Connection to Azure Managed server fails from .NET app but works when connection from the command line

I am trying to connect from an Azure virtual server (windows 10) to an Azure Managed SQL instance. From the command line on the virtual server I can connect to the managed SQL instance using: sqlcmd -S…
Columbo
  • 2,896
  • 7
  • 44
  • 54
0
votes
1 answer

How to move dataset from Azure Managed Instance to Azure SQL using SSIS with change data capture

How to move data from Azure Managed Instance to Azure SQL Database by using SSIS package with Change data capture feature in it? Please help me with links or documents.
shubhi jain
  • 29
  • 3
0
votes
0 answers

Using tiny_tds gem unable to connect to Azure Managed instance sql server

I'm in a linux container using the gem file tiny_tds (verions 2.1.1) to try to connect to sql server on an Azure Managed instance. The code I'm using to connect is this: client=TinyTds::Client.new(:username=>'username@full.server.name', :password=>…
ferris
  • 55
  • 9
0
votes
0 answers

How to optimize Azure Data FactoryPipeline?

Need help on the below requirement... I have to perform ADF migration from 90(source and target Azure MI databases) For Example Source on-prem servers(data server1, data server2, data server3,...data server90) to Target Azure MI Servers(Azure MI…
Hemant Sudehely
  • 49
  • 1
  • 10
0
votes
1 answer

Is it possible to copy a azure managed sql service database into an on-premise instance

I have a requirement to copy the azure managed sql service db into an on-premise instance. But when I searched on the topic, I am able to find options for migrating on-premise to azure managed service instance. But not the other way around. …
Subramanian
  • 67
  • 1
  • 10
0
votes
0 answers

SQL Server Linked Server not returning all results

I'm trying to read data out of a from a linked server and the join is bringing back only the first match. If I ran the query on the directly on the remote server I'd get multiple rows back. Both the local and remote servers are Azure Managed…
user2197446
  • 1,065
  • 3
  • 15
  • 31
0
votes
1 answer

Azure SQL Database - Cross Reference DB Queries - SP

We are currently doing a POC on migrating on-premises SQL DBs to Azure SQL Database. While migrating , we hit with an issue on applying schemas - few of the Stored procedure calls other DBs. Scenario is like we have central DB- A, and there is…
Renji
  • 391
  • 2
  • 7
  • 20
0
votes
2 answers

Restoring database in azure managed instance from one subscription to another

I have my production database in one subscription and dev/test database in other subscription. how can i restore database from production to test?
Priya Sharma
  • 35
  • 6
0
votes
1 answer

Export Azure Managed Instance Database backup to storage account

I am looking for an alternative to : New-AzureRmSqlDatabaseExport For the purpose of taking Managed Instance Database backup and export it to storage account. The above command, I think supports only SQL Server.
NaMo
  • 513
  • 1
  • 6
  • 19
1
2
3