Forum Widgets
Latest Discussions
Importing bacpac to Azure database fails
I am trying to import a database from a bacpac file to our azure sql server. I am following these steps: Creating a bacpac file from our production database running on an MS SQL Server 2022. Importing it into azure using sqlpackage But, it keeps failing with *** An unexpected failure occurred: Data plan execution failed with message One or more errors occurred. (One or more errors occurred. (One or more errors occurred. (Violation of PRIMARY KEY constraint 'PK_ForexQuote'. Cannot insert duplicate key in object 'dbo.ForexQuote'. The duplicate key value is (1). The statement has been terminated.))). The ForexQuote table DOES NOT have any duplicate primary keys. If I omit this table in my bacpac export I get a similar error on another table. I dont understand. What is going on here?
error when trying to execute sp_invoke_external_rest_endpoint
hi team i am using the following sql server version Microsoft Azure SQL Data Warehouse - 10.0.33054.0 Jul 9 2024 00:12:38 Copyright (c) Microsoft Corporation my college told me this is Azure Dedicated pool , but when i try this statement SERVERPROPERTY('EngineEdition') it gave me the value of 6 now the issue is :- this is my code , which is the REST API is working fine from postman tool ------------------------------------------------------ DECLARE @URL NVARCHAR(255) = 'https://date.nager.at/api/v3/PublicHolidays/2024/ZA' -- HTTP Request Parameters DECLARE @Object AS INT; DECLARE Hr INT; DECLARE @JSONResponse as NVARCHAR(max); -------------------------------------------------------------------------------- -- Perform HTTP GET Request to endpoint EXEC Hr = sp_invoke_external_rest_endpoint @url = @URL, @method = 'GET', @response = @JSONResponse output; SELECT Hr AS ReturnCode, @JSONResponse AS Response --------------------------------------------------------------------- it gave me the following error :- Msg 103010, Level 16, State 1, Line 1 Parse error at line: 10, column: 1: Incorrect syntax near 'EXEC'. any suggestions ????
how to export all tables from database
I'm recently started working in Microsoft Synapse and exploring the templates from the gallery available in Synapse "Database templates" and want to export all tables e.g. Automotive. I’ve tried using the DESCRIBE command, but it only gives information about a single table.How can I write a SQL query to exportall tables from the database template and export it to CSV? Is there a specific system view or query I should use in Synapse to achieve this? Any help would be appreciated. Thanks in advance!SQL MI firewall
During SQL MI deployment, a built-in firewall is deployed along with a dedicated virtual network (VNET). We can choose to access SQL MI using either a public URL or a private endpoint. Does this built-in firewall provide sufficient protection for SQL MI, or do we need to implement an additional firewall?Managed Instance - Start/Stop Schedule and Planned Maintenance (Updates)
HelloTech-Community, we recently startet to Shut-Down ourManaged Instanceover night when all Developers are a sleep. My question now is - when a [Planned Maintenance] is announced for Updating theManaged InstanceInfrastructure, what will happen if the Instance is down with a [Stop Schedule] ? Will the Patches be applied anyway - or will the Updates fail ? If anybody knows - please inform us. Thanks. Regards from Zürich _ Switzerland
Managed Instance intermittently logs me in as DBO
Intermittently Azure Managed Instance logs me in as dbo when I log in using Entra. I will wake up the next day to find the problem gone. This is an issue because when i try to create a new transactional replication publication I get Msg 15007, Level 16, State 1, Procedure sys.sp_grant_publication_access, Line 112 [Batch Start Line 17] 'dbo' is not a valid login or you do not have permission. Can anyone help me understand why Managed Instance sometimes logs me in as 'dbo' or should I raise a ticket..? FYI - I am in the Entra Admin group on the serverAzure SQL Database
Hi, i currently have a Microsoft Access application that uses data, queries, forms, report and custom vb coding. I'm looking for a modern cloud solution that i can use to recreate my application and then be able to offer to my clients via web link. Is Azure SQL database a reasonable tool for this high level requirement?
Copy schema (with data) from one Azure SQL database to another Azure SQL database
Hallo, We need copy 3 schemas (incl tables, indexes, keys and data) to another Azure SQL database. We decided to switch from 2 database to one more powerful. There is a lot of data, smallest database is about 1TB data. I tried do it SSMS or BCP on client VM but it does not work due amount of data and transfer speed. I am looking something to do this in Azure portal. Both Azure databases are on one Azure host. Current situation: database source A_DB schemas c11, c12, c13; about 1TB data in 300 tables database target B_DB schemes c21, c22, c23, c24, c25; Hyperscale and 3TB data Desired result: target B_DB after copying the schema consists from schemas with the date c11, c12, c13, c21, c22, c23, c24, database A_DB can be deleted Please advise what azure service or tool can i use for it. It's a simple task in Oracle but it look more complicated in Azure SQL environment. So far I have found how to exp/imp or backup/restore an entire database, but nothing about how i can import schema with a lot of data in Azure environment. Thank you
