Re: Database Diagram

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 16:50:14 +0530

Hi Kenne,

Those steps mentioned in the old post will work for SQL 2000 as well. It
uses DTS to exports the dtproperties table from source and load it in
detination.
Please delete the contents of destination before running the DTS.

FYI, I can see the diagrams after restoring the database to a different
server.

Thanks
Hari
MCDBA

"Kenny Kee" <keejh@hotmail.com> wrote in message
news:#VSNHNVdEHA.3132@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> FYI,
> I am using SQL Server 2000 in both ServerA and ServerB. The solution you
> guys help me is when SQL 7.0 to SQL 2000 if I am not mistaken.
>
> Again, I backup database from ServerA to ServerB but the disgram is
> blank, but when I update the diagram in ServerB and transfer back to
> ServerA, I can see it. Why?
>
> Thanks,
> Kenny
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: SQLSAC command line parameters?
    ... SQL Server MVP ... > fashion (either through sqlsac.exe, programatically, or some other silent ... > to configure the surface area for ServerA, ...
    (microsoft.public.sqlserver.security)
  • Cannot find Snapshot - SQL 2005
    ... Running Win 2003 & SQL 2005 on both machines. ... I created a publication on serverA. ... I changed to the location of the snapshot in the subscription ... initialized & receiving transactions from the publisher. ...
    (microsoft.public.sqlserver.replication)
  • Re: Database Diagram
    ... I am using SQL Server 2000 in both ServerA and ServerB. ... I backup database from ServerA to ServerB but the disgram is ... but when I update the diagram in ServerB and transfer back to ...
    (microsoft.public.sqlserver.server)
  • RE: change database servers for BTS2004
    ... ServerA - has Biztalk and SQL Database??? ...
    (microsoft.public.biztalk.general)
  • Re: Unable to execute a DTS with scheduled job
    ... I was connected to the serverA with windows account "sqloper" (users groups) ... and I run DTS with dtsrun.exe in a DOS session or with Enterprise Manager ... installed on the serverA and connected with a login without any "server role". ... This means you executing a package on ServerA from your ...
    (microsoft.public.sqlserver.dts)