I need to import a database (sql2k to sql2k) using dts, but when I do, I
loose the column text descriptions and the database diagrams. Is there a
way to get this information imported as well? I've spent a lot of time
documenting the column descriptions and creating diagrams and don't want to
loose it each time I do an import.

Thanks.

--
moondaddy (AT) nospam (DOT) com

Are you importing the entire database? If so, the restore command is much
faster and would include everything.


--
Ray Higdon MCSE, MCDBA, CCNA
---
"moondaddy" <moondaddy (AT) nospam (DOT) com> wrote

Hi
For diagrams you may want to check out
http://support.microsoft.com/default...b;EN-US;320125

The extended properties will be in the sysproperties.

John


"moondaddy" <moondaddy (AT) nospam (DOT) com> wrote

Hi,

Thank you for using MSDN Newsgroup! It's my pleasure to assist you with your issue.

From your description, I understand that you wanted to import a database as well as the
information of table column descriptions and database diagrams.

For keeping the information of the table column descriptions, you should import the database
using the third method "Copy objects and data between SQL Server databases". Please refer
to the following steps:
1. Expand the Databases folder.
2. Right-click the database you want to import the data, click All Tasks, and then click
Import Data
3. In the Data Transformation Services Import/Export Wizard, click Next.
4. On the Choose a Data Source page, select the server and database to which you
want to import. Click Next.
5. On the Choose a Destination page, click Next.
6. On the Specify Table Copy or Query page, click to select the Copy objects and data
between SQL Server database to transfer check box, and then click Next.
7. On the Select objects to copy page, select Including extended properties.
8. Select the objects to copy (should including the underlying tables that the diagrams
need or select Copy all objects)
9. On the Save, Schedule, and Replicate Package page, click to select the Run
Immediately check box, and then click Next.
10. On the Completing the DTS Import/Export Wizard page, click Finish.
11. Click OK, and then click Done to exit the wizard.

After that, you can see the column description in the imported database's tables.

For how to move a database diagram, I recommend you follow the step-by-step KB 320125
already mentioned by John:

320125 HOW TO: Move a Database Diagram
http://support.microsoft.com/?id=320125

One thing you may notice is that the table dtproperties creation will fail but it doesn't matter
because the diagram contents are exported/imported to the existed table dtproperties in the
database.

To suppress this symptom, you can also click Transform and in the Column Mappings and
Transformations page after you change the destination table name from Results to
dtproperties (step 8), and then select Drop and recreate destination table.


Does this answer your question? Please feel free to let me know if this help solves your
problem. If there is anything more I can still assist you with, please feel free to post it in the
group.


Best regards,


Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Thanks so much! That's exactly what I needed. I gotta tell ya, you guys
are providing a great service!!!


""Billy Yao [MSFT]"" <v-binyao (AT) online (DOT) microsoft.com> wrote

My pleasure and thank you for participating out newsgroup! : -)

Regards,
- Billy