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 |
|
benking9987
Posting Yak Master
124 Posts |
 Posted - 2009-03-13 : 13:56:31
|
| I am a DBA for a company that has two different divisions that operate completely apart from eachother. I have developed an inventory database that handles all of the needs for one division (which I spend 95% of my time with), now the second division wants the same technology for handling their inventory. What is the best way to copy all of the structure of my tables to another SQL server I have built in their division? Any suggestions would be helpful. Also, this may be a stretch, but is it possible to cascade updates from one database to the others to avoid having to duplicate my efforts each time I want to update the functionality? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-13 : 13:58:47
|
| do you mean duplicating just database structure alone or along with data? |
 |
|
|
benking9987
Posting Yak Master
124 Posts |
Posted - 2009-03-13 : 14:46:17
|
| Just the structure. I will populate the new database with data that applies to the other division of my company. |
|
|
|
Itamar
Starting Member
19 Posts |
Posted - 2009-03-16 : 17:20:44
|
| You could use the build-in import and export tool, but it can be done much more efficiently with some 3rd party tool such as SQL VERSION CONTROL SOLUTION - [url]http://nobhillsoft.com/Randolph.aspx[/url]http://www.nobhillsoft.comDatabase tools, SQL,MySQL... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Duplicating a SQL database