Changing the connection string

Posted by Community Admin on 04-Aug-2018 04:59

Changing the connection string

All Replies

Posted by Community Admin on 02-Feb-2011 00:00
Ok, so if you connect with connection string 1, with the user "steve", and you've used that to do all your development...

Then lets say you move servers and the login is now "sa"....so you update the details

OpenAccess regenerates ALL the tables again, so my DB is 1/2 DBO.TABLE1, STEVE.TABLE1

Posted by Community Admin on 08-Feb-2011 00:00
Hi Steve,

I am afraid this is related to the standard SQL server behavior. The whole db structure is created from scratch when sitefinity initializes for the first time. If the user that you used to connect and create the database wasn't a db owner, all the tables are automatically created with this user schema. If the initial user was dbowner they would have been with DBO schema. I guess your current option is to either somehow convert back to this initial user for the connection, or migrate the existing tables to the DBO schema, using ALTER SCHEMA statements. We are going to consider the option of forcing the tables to be created always in the DBO schema to avoid such problems.

Kind regards,
Nikolay Datchev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
This thread is closed