Deploying a Dacpac using SQLPackage
Hi, I'm trying to use SQLPackage to deploy a Dacpac using AccessToken authentication. I'm using the following command... .\sqlpackage.exe /Action:Publish /SourceFile:Database.dacpac /TargetServerName:xxxx.database.windows.net /TargetDatabaseName:DatabaseName /AccessToken:xxxx The error message I'm getting is: Unable to connect to target server 'xxxx.database.windows.net'. Please verify the connection information such as the server name, login credentials, and firewall rules for the target server. Login failed for user '<token-identified principal>'. Any ideas what's wrong here?
DATE_FORMAT is not supported for EXTERNAL FILE FORMAT.
I have been trying to create an external table from a CSV data set that does not use the default date format that synapse understands. So according to the documentation (https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-file-format-transact-sql?view=azure-sqldw-latest&tabs=delimited#examples) I should be able to specify a user defined format string as you can see in the picture below. But if I do so I get the following error "DATE_FORMAT is not supported for EXTERNAL FILE FORMAT." and I'm not sure what I'm missing in the documentation. I'm currently running in the Serverless SQL pool so could it be that this is just supported for dedicated pools? Thank you for your time and any help or insights would be greatly appreciated.
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
Azure SQL Web Portal .dacpac Functionality
I've had so far success in creating SQL Server databases using .bacpac through the Azure Portal web interface. That said, what I need is a way to update said databases' structures using a .dacpac through through the Azure Portal web interface as well. I understand this might be possible using SSMS, but I find the over the network interaction response time to be less than optimal. Is there such functionality available using the Azure Portal web interface (not to create a new database using a .bacpac file but to update its structure using a .dacpac file.) If not, will there be such a feature implementation in the near future?Zone redundancy
Now generally available in select regions, your new and existing Azure SQL Databases and elastic pools that use the general purpose tier can enable the zone redundant configuration. This configuration is offered for both serverless and provisioned compute. https://techcommunity.microsoft.com/t5/azure-sql-blog/zone-redundancy-for-azure-sql-database-general-purpose-tier/ba-p/3280376 Are you planning to shift to this configuration in the future? What scenarios will this help you with?Register for the Azure Hybrid and Multicloud Digital Event on June 29
Hear Microsoft leaders present the latest announcements about Azure Arc–enabled data services as well as news about other Azure Arc and Azure Stack HCI offerings. Also, watch engineering demos on how to organize and govern environments and use native Azure services—like data services—to run them outside of Azure datacenters. And, listen to customers discuss how they’re using Azure to achieve their goals and turn their hybrid strategies into reality. Register for the free, two-hour Azure Hybrid and Multicloud Digital Event on June 29 from 9:00 AM–11:00 AM Pacific Time and learn how to be more productive and agile by extending Azure management and running Azure data services across your on-premises, multicloud, and edge environments. The event kicks off with a short keynote followed by these deep dives into key topics and real companies’ experiences: Be among the first to hear a major Azure Arc announcement. Learn how to bring cloud capabilities to your data workloads across hybrid and multicloud environments. Intel and Microsoft: Partnering to deliver scalable, secure, and flexible hybrid infrastructure to customers. Run Azure data services anywhere with the latest developments in Azure Arc–enabled data services. See how SKF Group and Dell Technologies are getting the most out of the latest generation of hybrid data offerings. Quickly build, deploy, and update apps anywhere with Azure Arc. Learn how to ensure governance, compliance, and security for all deployments. Get consistent operations and security for hybrid and multicloud environments—and learn to automate systems to meet security, governance, and compliance standards. Modernize your datacenter and use Azure Stack HCI hybrid capabilities to help improve availability and performance across environments. You’ll also have the chance to get answers to your hybrid questions from product experts during the live chat and from Microsoft leaders during the live Q&A panel. Join us to hear more about these benefits, engage with Microsoft leaders and product experts, and explore solutions from the cloud built for hybrid. We hope to see you there! Azure Hybrid and Multicloud Digital Event Tuesday, June 29, 2021 9:00 AM–11:00 AM Pacific Time (UTC-7) Delivered in partnership with Intel. REGISTER NOW >Logging Firewalls and virtual networks traffic
When Azure SQL Auditing is enabled, will this capture network traffic for any IPs that have been configured for access in the Firewalls and virtual networks traffic section? I'd like to see any allow or deny traffic logs for SQL servers that have an ACL defined. ThxHourly pricing on SQL database Provisioned VS Serverless
Hi, I've beed searching and using the azure calculator to approximate a budget for a project I'm working on. Question 1: If the Provisioned tier doesn't have auto pause-resume, and you don't stopped manually ¿Why Azure calculator offers you to calculate price in a hourly demmand? Question 2: If the Serverless tier does have auto pause-resume, ¿Why Azure calculator doesn't offers you to calculate price in a hourly demmand? I trying to figure out the price of Serverless just for 10 hours of activity before the automatic stop takes effects. Best regards JonaDigital event: Innovate Today with Azure SQL on May 4
Stay on the cutting edge of cloud-based database possibilities at our latest Digital Event. Join us for the https://info.microsoft.com/ww-landing-Azure-SQL-Digital-Event.html?ocid=AID3030940_QSG_517226and find out how to build an effective cloud database management strategy to respond to today’s changing business needs and tomorrow's opportunities. Register now to: Learn how to build intelligent apps across your data workloads using the latest digital innovations from Azure SQL and attend on-demand sessions on IaaS (infrastructure as a service) to PaaS (platform as a service) migration, optimizing performance, and SQL Edge. Watch Microsoft MVP and Microsoft engineering-led technical demonstrations of Azure SQL database services, including serverless compute and Hyperscale. Hear from real customers about how they are transforming their organizations using Azure SQL right now. Get the answers to your questions from Azure SQL subject-matter experts. https://info.microsoft.com/ww-landing-Azure-SQL-Digital-Event.html?ocid=AID3030940_QSG_517226 and attend this live digital event for a chance to win Surface headphones (five winners total). Winners will be selected at random. Innovate Today with Azure SQL Tuesday, May 4, 2021 10:00 AM-11:00 AM Pacific Time NO PURCHASE NECESSARY. Open to any registered event attendee 18+. Sweepstakes ends May 4, 2021. For Official Rules, see https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Faka.ms%2FInnovateTodayAzureSQLsweepstakes&data=04%7C01%7Cv-kevinplatt%40microsoft.com%7Cce07019a5e0b426f8da908d8e420b014%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637510176327068038%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=jSZKv2i0EfhFAg9JB1EPwwGa0kvni1BOXLvP38bOMh0%3D&reserved=0.
