Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jul 26, 2012 04:17 PM by GmGregori
Jul 26, 2012 01:52 PM|LINK
I ended up having two databases on the same site. The startersite.sdf contains the standard stuff that came with the site, and the other database that I created.
I am getting ready to implement the administration aspect for my site and I can just imagine how dealing with two different databases is going to be a complication I don't want.
How can I move over the tables from one database to the other, within the same site?
Jul 26, 2012 02:02 PM|LINK
yes, we can have any number database and move over by just running the script or move it using Import/Export.
but its a bad idea to have multiple db for single application
Jul 26, 2012 02:07 PM|LINK
Thanks for your reply. I figured it would create an unnecessary complication.
I am not not familiar with running scripts so could you tell me what I need to import/export?Is this within Webmatrix? Will the relationships stay intact?
Jul 26, 2012 04:08 PM|LINK
For SQL CE databases you can use this tool (there is help available if you need)
for full version of SQL databases you can use Microsoft SQL server Managment Studio, but based on your post looks like you work with compact edition of sql
Jul 26, 2012 04:17 PM|LINK
This old thread could be a good starting point:
Copying Table Definition to a NEW TABLE in Databases (Using WEBMATRIX).