Exporting database from sql 2000
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10113
Printed Date: 30 March 2026 at 5:57am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Exporting database from sql 2000
Posted By: ultramods
Subject: Exporting database from sql 2000
Date Posted: 23 April 2004 at 12:48pm
|
I have just noticed a problem when i use the Export wizard in Enterprise Manager (SQL Server 2000). I use the option Copy objects and data between sql server databases. However when i run the DTS it transfers the databases and data ok. But it doesn't transfer my default of getDate() for my 'dateEntered ' column. Could anyone please help me with this problem, thanks. |
Replies:
Posted By: Semikolon
Date Posted: 23 April 2004 at 3:44pm
| try to find a defaults box or something similar |
Posted By: dpyers
Date Posted: 23 April 2004 at 5:00pm
|
IIRC, You have to "include all dependent objects", and perhaps extended properties. There's also a check box for "use standard options" that's set on by default. Turn it off and a button becomes active that allows more selections. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: ultramods
Date Posted: 24 April 2004 at 11:27am
| Thank you for both of you replies. |