Azure SQL
Make a backup of the database in bacpac from SQL Server
Through SQL Management Studio or Visual Studio Developer Command Prompt
Alternative option Developer Command Prompt
cd Common7\IDE\Extensions\Microsoft\SQLDB\DAC
SqlPackage.exe /Action:Export
Screenshots
100%:
Import the copy into Azure SQL using Blob
(To spend the least amount of money, create in vCore Serverless)
Connect the application that used the database to the Azure database
Once the snapshots are made, they can be deleted
Screenshots
Maximum:
Install the EF Core Power Tools extension. Create a .NET Standard library project. Generate a model from the database. Add a console application project. Create an instance of the context in it and output data from the database.
https://marketplace.visualstudio.com/items?itemName=ErikEJ.EFCorePowerTools
Client's review of cooperation with Vitaliy Basanets
Azure SQLThe freelancer's work was very pleasing. The performer is contactable, communicative, and knows their business. The task was completed very systematically, neatly, and with explanations. I plan to involve them in other projects as well.
Freelancer's review of cooperation with Iryna Trunova
Azure SQLWorking with Iryna was a real pleasure. The project was well organized, with clear requirements and constructive feedback. I look forward to further collaboration!
-
172 1 0 Good day! I will be happy to help you with your tasks as soon as possible!
Current freelance projects in the category Databases & SQL
Excel Specialist / Process Automation (Excel + preferably programming)We are looking for a specialist with ADVANCED knowledge of Excel to optimize the existing file and automate processes. It will be a great advantage if you also have programming skills / VBA / Power Query / Power Automate or experience in creating complex logic in Excel. Project… Python, Databases & SQL ∙ 17 minutes back ∙ 5 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 1 hour 23 minutes back ∙ 7 proposals |
1C database for the enterpriseA database is needed for managing the auto dismantling inventory, controlling finances, and generating orders. It is necessary to add a car as an object and attach parts to it. I will explain the full structure of how it should look and work during the conversation. Databases & SQL ∙ 10 hours 58 minutes back ∙ 5 proposals |
1C data integrationOrganize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 1 day 16 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 2 days 21 hours back ∙ 34 proposals |