View Single Post
Old January 3rd, 2010, 10:51 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts

Hi Nick,

You need to take the SQL script from your extra databases and run them *against* your primary database. Before you do so, you may need to remove the CREATE DATABASE and USE YourDatabaseName items if they are there. This way, the content (tables, data and more) are scripted from one database and then added to another. Then you'll need to update your connection strings to point them to the same database (or merge them into a single connection string).

To execute these scripts, use the SQL Server Management Studio, attach your primary database and run the other scripts against that database.

Does this help?

Imar Spaanjaars
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
The Following User Says Thank You to Imar For This Useful Post:
NickTUK (January 3rd, 2010)