I have a database server 192.168.5.1 ( Name TESTDB ) Local test database
192.168.5.2 have TESTDB (192.168.5.1 backup database recover) ( Name TESTDB ) Server database
Databases equal.
Local Test 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" />
publish 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" />
publish database (192.168.5.2) on update from database;
Error: "Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'cad.Device'
But; cad.Device exists in database.
http://prntscr.com/8qu7zx