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?
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?
TIA
Marked as answer by Dino He - MSFT on Aug 02, 2012 05:02 PM
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
wavemaster
Participant
1350 Points
1161 Posts
moving tables between databases within the same site
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?
TIA Robert
Mudasir.Khan
All-Star
15346 Points
3142 Posts
Re: moving tables between databases 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
wavemaster
Participant
1350 Points
1161 Posts
Re: moving tables between databases within the same site
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?
TIA
TOMCIO
Contributor
3648 Points
833 Posts
Re: moving tables between databases within the same site
Jul 26, 2012 04:08 PM|LINK
For SQL CE databases you can use this tool (there is help available if you need)
http://sqlcetoolbox.codeplex.com/
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
Web: Chicago Website Design
r@zorC - Open Source ASP.net CMS for WebMatrix
GmGregori
Contributor
5564 Points
749 Posts
Re: moving tables between databases within the same site
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).