Print Page | Close Window

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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net