| Computers Forum Index » Computer - Databases - MS SQL Server » Copying Database diagrams in SQL 2000... |
|
Page 1 of 1 |
|
| Author |
Message |
| Raziq Shekha... |
 Posted: Fri Oct 02, 2009 6:25 pm |
|
|
|
Guest
|
Hello all. SQL 2000 SP 4. I am trying to copy one Database diagram
over from my test server to my prod server. This particular database
has multiple diagrams in both test and prod. I just want to copy one
particular diagram that does NOT exist in prod over from test. I don't
want to copy over all the diagrams and I don't want to overwrite the
existing prod diagrams. Thanks in advance for any suggestions. Thanks,
Raziq.
*** Sent via Developersdex http://www.developersdex.com *** |
|
|
| Back to top |
|
|
|
| Raziq Shekha... |
| Posted: Wed Oct 07, 2009 1:41 am |
|
|
|
Guest
|
|
| Back to top |
|
|
|
| Malcolm Leach... |
| Posted: Wed Oct 07, 2009 10:40 am |
|
|
|
Guest
|
Our product, DB Ghost (http://www.dbghost.com) synchronises schema and
data and can include the sysdiagrams table.
It also has options to seelect whether you want "new", "missing" and
"different" stuff.
So, you could do a sync run (using the 14 day eval) where you specify
just the sysdiagrams table and "missing" stuff which will insert any
new rows in the target table. Beware of potential primary key
conflicts though - I would advise that you agree a set of standard
diagrams, store them in source control, and propagate them all the way
through your environments. That way eveyone can benefit and you can
maintain a version history via source control  ) |
|
|
| Back to top |
|
|
|
|
