CODEWITHSUNDEEP
c#visual-studio-2012visual-studio-lightswitch
Brannon
Brannon

Reputation: 5414

how do I duplicate LightSwitch DB structure in a second LightSwitch application?

Suppose I have two MS LightSwitch projects. I really like my table layout in one project and want to copy it to the other project. How is this done? What files have the table and key definitions?

Upvotes: 1

Views: 1263

Answers (2)

Humpel Heinz
Humpel Heinz

Reputation: 1

[WARNING: NEVER DO THE FOLLOWING! IT MESSES UP YOUR PROJECT IN VISUAL STUDIO]

What I did in LS 2013 was to create tables with the same name in the new project, so they are already "known" to your project settings. Then I went to [project folder]\[project name]\[project name]\[project name].server\DataSources\ApplicationData of the project I wanted the tables from. I copied the respective files (including script files, if you did data validation, which I also created in the new project with dummy entries) and then overwrote the files with the same name in the respective ApplicationData folder of the new project, which I had created.

When I loaded the project again, Lightswitch showed the new tables in my old project.

Upvotes: 0

Yann Duran
Yann Duran

Reputation: 3879

The easiest way would be to publish the application, then use a copy of the published database as an attached data source in the new project.

The defintions that you ask about are stored in an lsml file (a LightSwitch-specific XML file), ApplicationDefinition.lsml for LS 2011, & Common.lsml for LS 2012. But be VERY careful if you try to edit this file in any project, it only takes ONE mistake for the whole application to no longer load.

Upvotes: 1

Related Questions