Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
missMac
Posting Yak Master
124 Posts |
 Posted - 2009-09-09 : 09:21:57
|
| Hello guyswe are running MSSQL web edition.We have 2 databases1. for our forum users2. for all other users and applications/servicesHow do we merge both databases into 1. Bear in mind we have about 300 tablesWe tried using export/import wizard under tasks, but 1. If we create the tables using scripting ( the import fails and says read only )2. If we create the tables using import/export ( the contraints and PK are not created )Please adviceMM |
|
|
asgast
Posting Yak Master
149 Posts |
Posted - 2009-09-09 : 09:25:05
|
| ou can create constraints after importing the data |
 |
|
|
missMac
Posting Yak Master
124 Posts |
Posted - 2009-09-09 : 09:29:01
|
| that would take forever, we have over 300 tables. Is there no other simple way ??? |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-09-09 : 09:32:20
|
| you can use MS Database Publishing wizard to create scriptshttp://www.microsoft.com/downloads/details.aspx?FamilyID=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en |
|
|
|
missMac
Posting Yak Master
124 Posts |
|
|
|
|
|
Backup a few tables