Exporting Database Diagrams - SQL server 2005

Hi,

I'm trying to export my Database Diagrams to a new database. I've managed to do it by right clicking on the database->tasks>export data and followed the wizard instructions. The tables and Data Diagram show up fine on the new database however all the primary keys/relations/ are not present. Is there a way of copying the whole diagram to include all the primary keys and table relations?

Thanks :)

There is more info here:

http://msdn2.microsoft.com/en-us/library/ms171977(VS.80).aspx

But it sounds like there may be some SSIS options you need to set. Which destination are you using? And why export the diagram?

sql

Exporting Database Diagrams - SQL server 2005

Hi,

I'm trying to export my Database Diagrams to a new database. I've managed to do it by right clicking on the database->tasks>export data and followed the wizard instructions. The tables and Data Diagram show up fine on the new database however all the primary keys/relations/ are not present. Is there a way of copying the whole diagram to include all the primary keys and table relations?

Thanks :)

There is more info here:

http://msdn2.microsoft.com/en-us/library/ms171977(VS.80).aspx

But it sounds like there may be some SSIS options you need to set. Which destination are you using? And why export the diagram?

|||

Articles at the link above just give a primer on how to work with diagram designer: add/remove a table, add a note and the like, save the diagram as an object in its database.

The original question (and mine too) is - how to export the diagram outside of its database? At least maybe in a form of an image, if something like a Visio diagram is too much.

Personally, I like SQL Server's diagrams look and feel (for most part), the very much desired but missing functionality is copying a diagram into another database of the same structure. But if you think about it, the other DB does not have to be of the same structure, because the designer is perfectly capable of updating the diagram that you have saved before making changes to your schema! So how about that?

export to exce1

I am using subreport techique to include in my report layout. I can see all
the report and subreport (by clicking the toggle key) from the internet
browser. After exporting to EXCEL format, i can't see the subreport items.
What went wrong'
Thanks.What version/service pack are you using? Is your subreport contained in a
table?
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:94D59D45-FE59-4B88-8FE0-7A33080AFD31@.microsoft.com...
>I am using subreport techique to include in my report layout. I can see
>all
> the report and subreport (by clicking the toggle key) from the internet
> browser. After exporting to EXCEL format, i can't see the subreport
> items.
> What went wrong'
> Thanks.|||Hi Andy,
Thanks for your email.
I am using SQL 2005 (version 9.00.1399.00) and Excel 2003 SP2. The subreport
is contained in the detailed row of my table. This subreport is perfected
for my application, it return different number of rows and with hidden
property set to true. Each time click the toggle key it display the result
from the subreport. Unfortunately, it just could not display the contents of
the subreport when exported to Excel. Thanks for your attention. And would
like to hear your response.
"Andy Potter" wrote:
> What version/service pack are you using? Is your subreport contained in a
> table?
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Theresa" <Theresa@.discussions.microsoft.com> wrote in message
> news:94D59D45-FE59-4B88-8FE0-7A33080AFD31@.microsoft.com...
> >I am using subreport techique to include in my report layout. I can see
> >all
> > the report and subreport (by clicking the toggle key) from the internet
> > browser. After exporting to EXCEL format, i can't see the subreport
> > items.
> > What went wrong'
> > Thanks.
>
>