Changing the connection string - Bugs & Issues - Bugs & Issues - Progress Community
 Bugs & Issues

Changing the connection string

  • Changing the connection string
  • 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" you update the details

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

  • 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