This is a migrated thread and some comments may be shown as answers.

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

3 Answers 32 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
BekirSami
Top achievements
Rank 1
BekirSami asked on 13 Oct 2015, 01:44 PM

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 ? ​

 

3 Answers, 1 is accepted

Sort by
0
BekirSami
Top achievements
Rank 1
answered on 13 Oct 2015, 02:02 PM

screenshot link :screenshot

0
BekirSami
Top achievements
Rank 1
answered on 14 Oct 2015, 08:55 AM

other database on update from database;

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

But;  cad.Device exists in database. 

 

0
Kristian Nikolov
Telerik team
answered on 16 Oct 2015, 10:48 AM
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.
Tags
Databases and Data Types
Asked by
BekirSami
Top achievements
Rank 1
Answers by
BekirSami
Top achievements
Rank 1
Kristian Nikolov
Telerik team
Share this question
or