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
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 1 day 12 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 2 days 5 hours back ∙ 9 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 2 days 23 hours back ∙ 89 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 3 days 2 hours back ∙ 16 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 5 days back ∙ 6 proposals |