Update Database from Model to specified Schema

[David]

I am preparing to Update the database from a Telerik Data Access Model I have designed and I do not want the tables created in the dbo Database schema.  How do I specify which schema I want the tables created in?  I saw some instructions for adding ALTER SESSION SET CURRENT_SCHEMA=<new schema> in the Init SQL field of the Connection Pool under Backend Configuration, but this command does not work for MS SQL 2008.  

Thank you

[Boris Georgiev]

Hi David,

The SQL which you point out is for Oracle, not for MS SQL. The Init SQL which you should set to use a default schema other than "dbo" in MS SQL is:

ALTER USER yourUser WITH DEFAULT_SCHEMA = myschema;

Unfortunately if you are using Windows Authentication this SQL will not work.

There is a workaround - when you create a new Domain Class, you could change the schema for it from the Table Editor when you map the class to a new Table. You should have in mind that by default when you first map a class to a table, the Schema Name field is disabled, so you should map the class first, close the Table Editor and then open it again to edit the mapping.

I hope that helps.

Regards,
Boris Georgiev
Telerik