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?

Exporting Data from excel to SQL Server express

Hi

I have managed to add the DTS wizard as a tool and saved the routine. However, I do not know how to schedule my PC to automatically run this DTS procedure. I have tried to use scheduled tasks, but it does not seem to want to start.

Pls help.

It was absolutely amazing.

Just by typing in "SQL Server" and Excel in the search box on this page in the forums, I found these previous posting on the same topic...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1083746&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295895&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=970723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=304674&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=985930&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1083317&SiteID=1

There were more...

|||

Hi Arnie,

Thanks for the suggestion, I discovered a a previous post you made. You suggested that you get scheduled tasks to run dtsrun.exe. I do not have DTSrun.exe and surely you would have to make the executable run only your specified saved DTS 'routines'. How would you do this?

Regards

George

|||

Perhaps these will help guide you.

DTS - How to Run a DTS Package as a Scheduled Job
http://www.support.microsoft.com/?id=269074

DTSWizard.exe
http://go.microsoft.com/fwlink/?LinkId=65111

|||

Hi

Thank you for your help, but unfortunately the above solutions do not seem to work. Let me explain my situation more completely:

I have installed Microsoft SQL Server Express Edition with Advanced Services SP2 and the Toolkit. I have made the DTSWizard a tool in SQL management studio express I have transferred sample data into the database using the DTS tool. I have 'saved' the DTS transfer|||

For command line details about executing a 'package', refer to Books Online, Topic: dtutil