Telerik ORM, when changing the database as a new table showing

4 posts, 0 answers
  1. BekirSami
    BekirSami avatar
    12 posts
    Member since:
    Sep 2010

    Posted 13 Oct 2015 Link to this post

    I have a database server 192.168.5.1  ( Name TESTDB )

    192.168.5.2 have TESTDB (192.168.5.1 backup database recover)  ( Name TESTDB ) 

    Databases equal​.

     First Connection Strings

     <add name="​TESTConnection" connectionString="data source=192.168.5.​1;initial catalog=​TESTDB;persist security info=True;user id=​sa;password=test" providerName="System.Data.SqlClient" />

     Changed Connection String

     <add name="​TESTConnection" connectionString="data source=192.168.5.​2;initial catalog=​TESTDB;persist security info=True;user id=​sa;password=test" providerName="System.Data.SqlClient" />​

     

     It seems to be newly added tables. 

     Telerik Orm, I need to create wipe again. 

     

    How can I update without erasing ? ​

     

  2. BekirSami
    BekirSami avatar
    12 posts
    Member since:
    Sep 2010

    Posted 13 Oct 2015 Link to this post

    screenshot link :screenshot

  3. DevCraft banner
  4. BekirSami
    BekirSami avatar
    12 posts
    Member since:
    Sep 2010

    Posted 14 Oct 2015 Link to this post

    other database on update from database;

    Error:   "Telerik.OpenAccess.RT.sql.SQLException: Invalid object name​ 'cad.Device'

    But;  cad.Device exists in database. 

     

  5. Kristian Nikolov
    Admin
    Kristian Nikolov avatar
    206 posts

    Posted 16 Oct 2015 Link to this post

    Hello BekirSami,

    Thank you for contacting us.

    If I am understanding correctly, your scenario is such that you change the connection string so that the model targets the backup version of your database. When you try to update, the wizard shows that you are adding a table.

    If this is correct, the reason for the behavior could be that there are differences between the model and the database and the Create Database option is selected on the Select Changes screen of the Update Database from Model wizard. In case you need to update the database without attempting to add the table you need to select the Migrate Database option. Then you will be able to see what are the changes in the model, that you attempt to push to the database.

    If the error you mentioned still occurs after updating the database, please tell us what is the operation that causes it - are you executing a query, or something else?

    I hope this helps. Feel free to get back to us if you have any more questions.

    Regards,
    Kristian Nikolov
    Telerik
     
    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
Back to Top