I have a new project where I have created some custom tables using a migration plan. This is all working fine on my local machine but when I exported it to a live system instead of using the dbo schema all the other tables have used it put it in a schema named as the login name.
You have 2 opitions (where i'm aware of): prefix the tablename in your migrationplan with "dbo.tablename" or change the default schema for your SQL databaseuser (in my opion the best option, also when upgrading Umbraco in the future).
In SQL Management Studio you can do this under "Security", "Logins", "User Mappings"
Umbraco 8 adding a database table
I have a new project where I have created some custom tables using a migration plan. This is all working fine on my local machine but when I exported it to a live system instead of using the dbo schema all the other tables have used it put it in a schema named as the login name.
Hi Daniel,
You have 2 opitions (where i'm aware of): prefix the tablename in your migrationplan with "dbo.tablename" or change the default schema for your SQL databaseuser (in my opion the best option, also when upgrading Umbraco in the future). In SQL Management Studio you can do this under "Security", "Logins", "User Mappings"
Best regards,
iNETZO
is working on a reply...