Search This Blog

Wednesday, December 11, 2019

How to Backup Azure SQL Database to Local - Part 2

Continue from Part 1, we are going to explore next tool to backup Azure SQL Database to local.

Tool 2:- Use SQLPackage Utility. This tool will create BACPAC file from a command line. You can run unattended/automatically using batch file & scheduler.

[Pre-requisite]
Download SQLPackage from here
or 
Download Visual Studio Community. Install Data Storage & Processing
Install Analysis Services & Reporting Services, Integration Services component in Visual Studio Market Place. Click here

[Begin]

Query the location of SQLPackage by typing command "dir sqlpackage.exe /s /p"



[ Backup ]

Execute command 

Command:
sqlpackage.exe /Action:Export /ssn:tcp:<location> /sdn:<dbname> /su:<username> /tf:c:\backup\<dbname>.bacpac /sp:<password> /p:Storage=File

Example:
sqlpackage.exe /Action:Export /ssn:tcp:testdb1.database.windows.net /sdn:testdb1 /su:ericlaiys2019 /tf:c:\backup\testsqlpackage.bacpac /sp:1234567890@ms4u /p:Storage=Fil



Stay Tuned for Part 3.


Monday, December 9, 2019

How to Backup Azure SQL Database to Local - Part 1

In this post, we are looking into a way to backup Azure SQL Database which resides on PaaS to local or back to customer on-prem.

This is Part 1 of the tools.

[Pre-requisite preparation]


  • Create any Windows VM operating system. We used Win 10.
  • Install SQL Server Management Studio (SSMS). It require the latest DAC library installed.To download, click here
  • Add Service endpoint on virtual network. Go to Virtual Network > Add Service Endpoint > Microsoft.SQL

  • On SQL Database, open Azure SQL Database Firewall to allow access to the VM



Tool 1: Export a Data Tier Application Using SSMS


  • Open SSMS Tools and Connect to your Azure SQL Database
  • Right click select your database > Tasks > Export Data Tier Application


It will create BACPAC file which will create an exact copy of the database.

This process is manual procedure.

Review Part 2 here.

Thursday, November 21, 2019

ALTARO - Holiday Contest 2019 - Great Prizes to be Won



This Holiday Season, Altaro is helping you out with your Holiday Shopping: they’re giving you the chance to WIN fantastic gifts that you can give to your loved ones! 
It’s no secret that Holiday shopping can be stressful and very time-consuming. So this year, whether you need a present for your partner, your children, your parents and in-laws, or your friends… Altaro’s got your back. Enter and share it on socials for a chance to WIN one of the Grand Prizes: a Holy Stone GPS FPV RC Drone HS100, an All-Access MasterClass pass, 
Lomography Lomo’Instant San Sebastian, an Echo Plus (Smart Home Hub), a Wii Console & Mario Kart for Wii, 2x Netflix Gift Cards of $100 each, and a JBL Clip Portable Waterproof Speaker. 
And guess what? For any eligible subscription they give you a guaranteed Amazon voucher! 
So, if you are a Hyper-V or VMware user, download Altaro’s VM Backup and follow the instructions you will find over here to WIN these exciting prizes! 

Good luck & Happy Holidays! 

Friday, November 8, 2019

FREE Webinar - Fast Track your IT Career with VMware Certifications


Everyone who attends the webinar has a chance of winning a VMware VCP course (VMware Install, Config, Manage) worth $4.5k!




Climbing the career ladder in the IT industry is usually dependent on one crucial condition: having the right certifications. If you’re not certified to a specified level in a certain technology used by an employer, that’s usually a non-negotiable roadblock to getting a job or even further career progression within a company. Understanding the route you should take, and creating a short, medium, and long term plan for your certification goals is something everyone working in the IT industry must do. In order to do this properly you need the right information and luckily, an upcoming webinar from the guys at Altaro has you covered!

Fast Track your IT Career with VMware Certifications is a freewebinar presented by vExperts Andy Syrewicze and Luke Orellana on November 20th outlining everything you need know about the VMware certification world including costs, value, certification tracks, preparation, resources, and more.

In addition to the great content being discussed, everyone who attends the webinar has a chance of winning a VMware VCP course (VMware Install, Config, Manage) worth $4.5k! This incredible giveaway is open to anyone over the age of 18 and all you need to do to enter is register and attend the webinar on November 20th! The winner will be announced the day after the webinar via email to registrants.

VMware VCP Certification is one of the most widely recognized and valued certifications for technicians and system administrators today however the hefty price tag of $4.5k puts it out of reach of many. The chance to get this course for free does not come along every day and should definitely not be missed!