Historically when performing content migration with Sitecore we used to deal with database backups. In a modern SaaS world, we do not have the luxury of neither managing cloud database backups, nor the corresponding UI for doing this. Therefore, we must find an alternative approach. Technical Challenge Let’s assume we have a legacy Sitecore website, […]
Posts Tagged ‘database’
Databases from the Future: What is Database Version 954?
Have you started up a new Optimizely site, and prepared your database only get to this error message? Reading the error message itself, you’ll see that the created DB version is at 957 where the current version of Optimizely, at the time of this writing, is 904. Where did this come from? How do […]
Upgrading Sitecore Platforms – Changes in Sitecore 10.x
So, you find yourself in a need of a Sitecore upgrade and don’t know what to start with or how to approach it? This series of blog posts will cover the whole process from zero to hero, or in upgrade terms – from planning to going live. It comes in the form of a guide […]
Load Data From Amazon RDS to Snowflake Using Matillion ETL Tool
Amazon Relational Database Service, a service provided by Amazon Web Services, is a fully managed SQL database cloud service that allows you to create and operate relational databases. With Amazon RDS, one can access all the files and database anywhere in a cost-effective and highly scalable way. Snowflake is a cloud-based platform that helps data […]
Understanding CRUD Operations Using PnP PowerShell
Create, read, update, and delete (CRUD) is an acronym used in database-related functions. James Martin probably coined the term (CRUD) in his 1983 book Managing the Database Environment. We can use the following models to execute basic CRUD operations in SharePoint: REST-API Object Model. JavaScript Object Model Client-Side Object Model Server-Side Object Model We must […]
[Part 2 of 2] How to Refresh Your Marketo Data for the New Year
New Year, New You… continued! Last week, I asked you to take a moment and think about your Marketo instance. When was the last time you focused purely on data hygiene for marketing automation? It’s a fresh new year, and now is the perfect time to refresh your data! As such, I posted a list […]
[Part 1 of 2] How to Refresh Your Marketo Data for the New Year
New Year, New You! It’s 2022! Take a moment and think about your Marketo instance. When was the last time you focused purely on data hygiene for marketing automation? If you’re like most Marketo Admins, it’s tough to find the time – but you know how important it is. Never fear, I’m not judging you! […]
How to Set Up Replication in MySQL
MySQL replication is a real-time mechanism that automatically copies or replicates data from one server to another backup server. Database administrators can use the master-slave replication procedure to replicate or copy data from multiple servers at the same time. This allows the database administrator to create a continuous live backup of the database. They can […]
Page Preview Master/Web Paradox
Does this scenario sound familiar? Sitecore CM/CD are on different servers Developer doesn’t have access to the CD server that is currently showing an error in the browser. Code base for both CM and CD are the same. Developer switches the database from Master to Web in CM and then previews the page but no […]
Optimizely/Episerver DXP Deployment API – Smooth Deployment Public Release
In my previous posts, we went over the deployment process in the Optimizely/Episerver DXP environment. The first and the second post of the Deployment API series went through the original methods that allow for deployment into the DXP environment. Smooth Deploy is a feature that I have been looking forward to for a long time now. It […]
DXP Deployment API – Azure.Storage Error Fix
As of March 29th, Microsoft made the decision to publish new VM’s which archived a bunch of Az, Azure, and AzureRM modules. The side effect of this was that when any of the deployment API scripts were run in Azure DevOps, it would throw an error. ‘Azure.Storage’ version 4.4.0 or greater is required. At C:\Users\VssAdministrator\Documents\WindowsPowerShell\Modules\EpiCloud\0.13.15\EpiCloud.psm1:189 […]
EpiServer DXP Deployment API – Direct Deploy
As of Update 357, Optimizely (EpiServer) released Direct Deploy into their Deployment API, Episerver.PaaS.EpiCloud. This update changes a couple of my scripts to allow major speed improvements when deploying into the integration environment. In this post, we will go through the following: How does the current deployment to Integration work? Why Direct Deploy? Why does […]