A backoffice plugin which allows users to view any migrations installed on an Umbraco instance. This is useful for any Umbraco admins who use bespoke migrations in their own code or simply want to check which versions of Umbraco were installed when. The tree view is currently powered by…

Umbraco package that helps you test package migrations without having to install a complete package over and over again. Simply install this package. Go to the setttings section Select the assembly name from an overview select the migration you want to test using the migrate button. Release n…

Hello everyone in the fabulous Umbraco community. I hope you have had a safe and happy holiday (Christmas for those of you that celebrate it) and my best wishes go out to you all for the new year. I'm kicking off 2021 with a major upgrade of our main corporate website to Umbraco 8. Cloud is also on…

Hello, I've created a subscribers table using migrationgs (very interesting). I want now to add data to myTable ...using Migrations? I've built a class that I thought would do this using the insert.IntoTable("myTable").Row(takes an object).Do() ...but I don't see where I can pass in my data model…

Hey all, I'm currently trying to implement Migrations withing Umbraco but a problem occurs when i try to run multiple migrations. The migrations should run while installing a package so in the installer file that is called from Umbraco. So I got a package with a migration in it. If it is installed…

Hi community. I'm using migrations to update some property types. So, when an exception occurs in Up() method, it seems to me that Down() should be executed, right? But it's not happening. In neither of my migrations, Down() is never executed. I'm interested in an explanation of how it's working…

Hi everyone. I'm undertaking a bit of a proof of concept project to create a migrations framework/api for umbraco. Taking inspiration from Fluent Migrator. I'm wondering if anyone has tried this before or if there's something else that could do what I want. We've used uSiteBuilder in the past qu…

Hi, I'm using Umbraco Migrations to update a bespoke database in our code for an Umbraco 7.3.0 web app. Currently I have an app setting in the web.config which tells an `MigrationRunner` which version of the product the web app should be running on. My code is done in various version 1.0.0., 1.1…

I have been trying to create a migrator for the Our Umbraco Migrations package but it doesn't even run. The basic structure of the class looks like this: [DataTypeMigrator("Imulus.UrlPicker")] public class ImulusUrlPickerMigrator : JsonContentMigrator { public override string…

Hi, Upgraded from 8 to 10 earlier and also upgraded umbraco forms. In backoffice/Packages/Installed packages there is a button "Run pending migrations" for umbraco forms. When I press this, I get a message "Package migrations have successfully completed.", but the button "Run..." still remains. T…

Umbraco Community,   I've recently joined a company that uses Umbraco 4 for their website. I am currently looking at the discussion of moving to V7 and I'd like to consider the impact of moving a website from 4 to 7. How is the backward-compatibility for V4 to V7 for an existing website or am I…

I've been experimenting with using Umbraco migrations for creating tables and such. I've had success with using the Umbraco database, and adding/removing tables to it with migrations. For instance by using the context database ( ApplicationContext.Current.DatabaseContext.Database;). Is it possible…

Hi, Is there any SQL files equivalent to migrations that included in Umbraco. core Conversion of Code first code existing here: [Umbraco Updates/Migrations][1] [1]: https://github.com/umbraco/Umbraco-CMS/tree/7ee510ed386495120666a78c61497f58ff05de8f/src/Umbraco.Core/Persistence/Migrations/Upgr…

Hello, I followed this article ([https://cultiv.nl/blog/using-umbraco-migrations-to-deploy-changes/][1]) to create migrations. However, when I read the comments, I saw Shannon say that apparently, it's not recommended to use "ApplicationContent.Current" in migrations context. However, I'd like my…

Having a go with v8 but noticed that some of the db method have gone private so not sure how to do the following: https://creativewebspecialist.co.uk/2013/07/16/umbraco-petapoco-to-store-blog-comments/ if (!db.TableExist("BlogComments")) { //Create DB table - and se…

Hi, I've created a nuget package, and I want to have an action executed automatically on the install of the package (for the moment, there is a button on a dashboard to do it) The action is the automatic creation of document types. Is there a way to do that ? Regardsthanks. I'll have a lookHi Didier…

Hi Community, I am trying to understand whether database upgrades run within a CI/CD setup. On my local machine i upgrade my version of Umbraco via Nuget and when i browse to the site it asks me to login so the system can upgrade. Once completed the web config gets the new version of Umbraco inser…

We have some table with different migrations plan. But we get some issue when we recreate a complete new environment, as the fields in the last model are created. So later migrations fails because fields already exists. Is there anyway to define a field with a certain version with the persistence…

I want to create and publish a package which just contains some views, partial views, a dll and creates a custom table in the default umbraco database. Does anyone know the best way to go about making this happen in a package please? Thanks PaulHi, for creating tables / config, you should look at…

Hi, I'm creating a package containing template, documenttype, macro, view, etc etc. This package will be deploy in different web site. If I make change to the package, how I can distribute across the different site without losing data? The only possibility that I see is to unistall and then instal…

Hi, We're trying to upgrade our site from 7.15.3 to 8.4.2 and the upgrade process is taking forever. I can see there is a lot of SQL updates going on and I was wondering if these are available as SQL scripts that can be run directly in SSMS rather than waiting for the application to do this? I've…

Any can help me on this error. when i upgrade 7.15.10 to umbraco 8.1.0 {"@t":"2023-10-05T11:11:01.4543898Z","@mt":"Database configuration failed","@l":"Error","@x":"System.InvalidCastException: Invalid cast from 'System.DateTime' to 'System.ValueTuple`2[[System.Nullable`1[[System.DateTime, mscorlib…

Hi, I have some data in custom tables that I want to be deployed using content flow in my cloud projects. How would I do this ? I had a look at ValueConverters but that is meant to be used for transfering content from a specific property editor. My data will be used inside the content (eg placeh…

Is there any automated way to change obsolete data types in Umbraco 7.6.3 version while migrating to 8.0.Hi Biplab I think there is an example of how to write an archetype - nested content migrator inside the Our. Umbraco. Migrations source: https://bitbucket.org/proworks/our.umbraco.migration/sr…

Hi there, We want to store a key value pair for our application and update the value periodically. Is it "allowed" to store our own date in the table umbracoKeyValue or will this break stuff? I can't find any documentation on this table. I know that is used for migrations, but don't know if we can…

Hi all, Anyone tried migrating Nested Content in Umbraco 10 to the Block List editor before? Will you be able to point me to the right directions if you had tried them before? ThanksOh thanks Mark Hi Jay uSync Migrations has a migration for Nested Content to Block List that might be of inspirati…

Hi All I am trying to setup EF core to create new tables in umbraco 13.2.0 and using this [link][1] for refrence.![enter image description here][2] but GetPendingMigrationsAsync and MigrateAsync is missing and not recoganized as extention method, Is there any change in umbraco 13 to use migration…

(Edit: I can't seem to post this to a proper category. My apologies.) I am trying to use a custom migration to alter a custom table in the database. My problem is that although the umbracoMigration table is updated with seemingly correct information about my custom migration after using Execute on…

Hi I'm trying to write some migrations for a node that contains a related links with media property.   In PropertyTypeExtensions when it tries to retrieve the data on var dataType = ApplicationContext.Current.Services.DataTypeService.GetDataTypeById(propertyType.DataTypeId)   dataType is r…

Hi I have been doing research to feed into a proposal to use Umbravo as a corporate CMS at a large organisation and migrate two existing web sites to the CMS. The scope, as well as the migrations, is to install and configure Umbraco on Azure, brand it, train staff, produce handover documents and pro…

Hi I'm using the API for migrations and as part of a migration I call: return ServiceContext.ContentTypeService.GetContentType(docTypeAlias); Occasionally that will just blow up with "An item with the same key has already been added." I was just wondering if theres a way to check if that ha…

I accidentally upgraded umbraco via nuget from 7.3.7 to 7.5x I then logged into my sites back office and proceeded (regretfully) to follow the upgrade/install steps until completion. Everything was working fine. *Important: I did not back up the DB before upgrade. Then I realized that I did not w…

Using the UmbracoFileSystemProviders.Azure project and ImageProcessor. We have an issue where we are using a single blob storage and the user deletes media from either our dev or staging. This is causing us a bit of grief because it then kills our courier migrations. Is there a setting in the .conf…

So we have a client that use UaaS. They have now asked for a feature that requires a couple of custom DB tables. So the big question - how do you do this with UaaS?? Normally I would just connect to the DB, create the two tables and use the PetaPoco in Umbraco to add entries and fetch them. A comple…

Hi, I need to migrate content from a v7 umbraco site to a new v10 install. What is the best approach for this ? Will uSync work i.e. will the structure of the data being exported from the v7 work with v10? I need to migrate content, media and members. If anyone has any other ideas, I'd really app…

I want to add some more tables to my existing cloud database. I selected the SQL Server CE as my database connection type. So it creates the Umbraco.sdf file in App_Data folder. So what can I do for this to add and update new tables?Hi Ram! If you follow the docs on how to work with databases on Um…

Hello, Can someone help me or point me in the right direction? I'm trying to create a subscribe list for my website using the API. Do I need to use migrations to create a table? I'm finding migrations confusing and haven't found anything to help me understand this better. I've read the database…

I am trying to create a simple table using Umbraco's database migration system, and I can't figure out how to create a table with a composite primary key. Here's an example of the code I am trying to use: using Umbraco.Core.Migrations; using Umbraco.Core.Persistence.DatabaseModelDefinition…

Morning all! Hope everyone is safe and well. I've noticed that a data type record gets created in the cmsDataType table only once it is used for the first time. The reason I noticed this is that we run migrations via the api for creating properties on nodes. The issue we've found is that then whe…

How can I create a custom table in umbraco CMS from a package? I wanted to create a table in umbraco CMS where I will save my License key and other key values. Please help in this regard or any other way to save License keys in Umbraco against the package?Hi Amna, You can use the migrations framew…

From time to time, with any CMS we come across the need to mass update a set of documents in some way - something needs changing that we hadn't planned for. For example a mass replace of the values in a specific property on a number of pages. I have looked at the SQL tables in Umbraco and could pro…

Creating a Custom Database Table In Umbraco it is possible to add custom database tables to your site if you want to store additional data that should not be stored as normal content nodes Below you will find an example that sets up a database table by registering a component in a composerImplem…

I'm using uSync Migrations to go from 8 to 13 and it's working great. However I'm confused about adding my own migrators. I compiled uSync.Migrations.Migrators.dll with my own additions and added it to the website project in a /lib folder. I added it as a project reference from there. Whenever t…

Is IContentService the only way to retrieve content when running a custom migration (inheriting from MigrationBase) Is there any way I can get PublishedContent Context? I want rapid read-only access without hitting the database.Hi Drummerboy, The answer kind of depends, you could inject in a IUmbr…

Hi I have a website which is running on Umbraco 8.17. I would like to upgrade this to the latest version of Umbraco 10. What steps would i need to take in order to get this to the latest version of Umbraco 10? After reading around some suggest to upgrade to 9 then 10. Could i continue using the…

Hi everyone, I am in the process of upgrading an Umbraco 8 project to Umbraco 13. I’ve successfully migrated document types, data types, and translations using uSync migrations. I also used the uSync.Forms package to migrate the Umbraco Forms themselves. However, I’m now looking to migrate the for…

Hi, I'm upgrading umbraco from 4.11.10 to latest (7.2.5). I've read general upgrade guide and version specific guides and they all makes sense. I already went (on dev) from v4.11 - v6.0 and after hitting problem when going directly to v7: Umbraco.Web.Install.InstallException: The database fa…

Hi Devs, I developed a new feature in an Umbraco v7 website where a new custom table is needed. In order to automatically update the database schema I developed a new custom migration (not the first time for me with migrations). The migration is executed correctly in development and staging environm…

Hi, We are trying to upgrade our umbraco project ( v8.02) to the latest version (8.1). But after starting the upgrade, an error occurs. (See screenshot + logging for details. What can we do to fix this issue? Arie ![enter image description here][1] [1]: /media/upload/447bd4d1-e396-4948-9475…

Within Umbraco there are some really handy tools for creating tables from DTO object definitions, saving you having to explicitly define your DB table structures. public class MyModel { public int Prop1 { get; set; } public int Prop2 { get; set; } public int Prop3 { get…

Is there any decent documentation regarding package actions anywhere? Most of the the documentation and articles that I've found are either out of date or link to sites that don't exist anymore!Hi Kevin, Thanks for the info, this is a great help. Thanks for the links. Cheers, MarcHi I can't tal…

Hi there, I have an issue with many people encountering the same issue when they migrate from Umbraco 7.15 to Umbraco 8.1, that is the System.InvalidOperationException: Nullable object must have a value error in the logs, I have specified in the web config to debug with further info, but there is no…

Hi everyone, so, a bunch of questions on the best practices :) there are 2 projects 1) vanilla umbraco project with custom macro and designs 2) asp.net mvc project, with ef6 code-first db derived from IdentityDbContext as of now those are 2 separate projects, 2 different databases, and 2 differen…

We recently migrated our major web project to Umbraco 11 from Umbraco 7 using uSync Migrations. Everything went fairly smoothly, but since we've gone live I've noticed the rollback section isn't reporting changes correctly, if at all! It seems to be stuck on the same red and green changes on every…

Hi, I migrated from 7 to 8, 9, 10, 11 Somehow, when I upgraded to 11, when I click on each item in the tree I only have Meta data, but the Properties tab somehow gone, disappear. Not sure what happened - when I migrated to 8/9 etc. it was still there. Then suddenly on 11.1 I can't see it on any i…

Hi, As of recent, it would appear that Powershell scripts are no longer used to populate and remove files on Nuget package installation/ uninstallation. It would appear that it is all managed using MsBuild. I am creating a package for Umbraco and have successful migrations on installation. The file…