Moving Database Source Table to a different Database

Question

I've been trying to read between the lines of some similiar post but haven't seen this answered directly. I have an application that connects directly to several related tables on the same Database. I need to move the tables to a new Database. Will I need to create my screens again from scratch after moving the tables or will everything be intack after updating the datasource?

Answer 1

You would need to update the data binding on any objects using the old datasource and update to the new. The new datasource would have to have the same "shape" (i.e. same fields) as the previous datasource.

Unfortunately the databinding cannot be updated from the UI once created. You could open the ApplicationDefinition.lsml file and update ContentItemDataSource. I haven't tried this so best to backup the project first before trying.

Answer 2

Thanks, I'm basically migrating the current tables over. I'll try updating the ApplicationDefinition.lsml file after the move.

Answer 3

I finally had a chance to test the steps provided. I was actually able to get it to working following the steps above or also just by doing the following.

I chose update datasource and hit the previous button on the choose database objects screen.I then pointed it to the new DB and updated as usual. I then just renamed the DB folder in solution explorer window. Saved  the file and the ApplicationDefinition file was updated as required.

Again thanks for the help.