importing sql2005 database diagram to word doc

Hi I have a large database diagram and am only displaying the table names and
relationships. When I copy the diagram to the clipboard and paste it to a
word doc the diagram is hard to read because the letering on each table
appears quite small. I tried changing the zoom within management studio
prior to the copy but it has no effect. Any ideas or is there a specific
method of exporting the image other than just copy to clipboard and paste?
thanks.
--
Paul G
Software engineer.If you take a big diagram and squeeze it into a small space, I don't
know how to avoid the text getting small. I know that when I wanted
to print a diagram to a single page the approach I took was to expand
it to 200%, copy it, then past it into Irfanview and print from there.
I could also save it from there as a jpeg. I suppose you could try
that, and then see if placing the jpeg into the Word document works
any better, but I would not hold out much hope.
Roy Harvey
Beacon Falls, CT
On Fri, 25 Apr 2008 09:46:00 -0700, Paul
<Paul@.discussions.microsoft.com> wrote:
>Hi I have a large database diagram and am only displaying the table names and
>relationships. When I copy the diagram to the clipboard and paste it to a
>word doc the diagram is hard to read because the letering on each table
>appears quite small. I tried changing the zoom within management studio
>prior to the copy but it has no effect. Any ideas or is there a specific
>method of exporting the image other than just copy to clipboard and paste?
>thanks.|||thanks for the information. I ended up just using the table names to gain
some space and was able to move the objects around (closer together) within
SQL Server Management Studio. Have not heard of Irfenview, might have to
check it out.!
--
Paul G
Software engineer.
"Roy Harvey (SQL Server MVP)" wrote:
> If you take a big diagram and squeeze it into a small space, I don't
> know how to avoid the text getting small. I know that when I wanted
> to print a diagram to a single page the approach I took was to expand
> it to 200%, copy it, then past it into Irfanview and print from there.
> I could also save it from there as a jpeg. I suppose you could try
> that, and then see if placing the jpeg into the Word document works
> any better, but I would not hold out much hope.
> Roy Harvey
> Beacon Falls, CT
> On Fri, 25 Apr 2008 09:46:00 -0700, Paul
> <Paul@.discussions.microsoft.com> wrote:
> >Hi I have a large database diagram and am only displaying the table names and
> >relationships. When I copy the diagram to the clipboard and paste it to a
> >word doc the diagram is hard to read because the letering on each table
> >appears quite small. I tried changing the zoom within management studio
> >prior to the copy but it has no effect. Any ideas or is there a specific
> >method of exporting the image other than just copy to clipboard and paste?
> >thanks.
>|||On Fri, 25 Apr 2008 14:00:00 -0700, Paul
<Paul@.discussions.microsoft.com> wrote:
>Have not heard of Irfenview, might have to
>check it out.!
Irfanview is a free utility for viewing image files, but it also has
some manipulation ability such as changing resolution. A great
utility, but nothing unique.
Roy Harvey
Beacon Falls, CT

Importing MS Access queries and relationships to MS SQL Server

Dear fellow programmers,
I am having a big problem on how to import queries and relationships
from MS Access to SQL Server. Any suggestions will be a great help & will be
appreciated.
Thanks in advance,
Jeri
What is the specific problem? More generally, understand that there are
differences between MS Access and SQL Server.
"Jir" <Jir@.discussions.microsoft.com> wrote in message
news:CE9B458D-6EAA-4678-87E5-08CC7D5D8739@.microsoft.com...
> Dear fellow programmers,
> I am having a big problem on how to import queries and
relationships
> from MS Access to SQL Server. Any suggestions will be a great help & will
be
> appreciated.
> Thanks in advance,
> Jeri
sql

Importing Access?

If I import an MS Access 2002 database into SQL Server, will it carry over
all my tables and table structures and my relationships, or will I need to
make major changes to them after?
Does it change the data types of fields as appropriate to match SQL data
types or make them all a generic one?
Thanksit depends on how you do it. if you are using the upsizing wizard then you
will get your tables, and data, etc. however you will have to go back in and
do a check to make sure everything is right. I have had varying degrees of
success with it and relationships ususally need to be recreated. Sometimes
drops the primary keys and indexes as well. you will also need to do some
coding. If you are using DTS than you can use the transforms in DTS to add
constraints, create indexes, etc. and this will give you better control over
how the data comes accross. but more control = more work upfront.
good luck
Neil MacMurchy
"Keith" <@..> wrote in message news:O13iNZcBEHA.3568@.tk2msftngp13.phx.gbl...
> If I import an MS Access 2002 database into SQL Server, will it carry over
> all my tables and table structures and my relationships, or will I need to
> make major changes to them after?
> Does it change the data types of fields as appropriate to match SQL data
> types or make them all a generic one?
> Thanks
>