September 24, 2002 at 4:19 am
Hi!
i have a question please help me:
When I import a Database, that i create on 6.5, in SQL 7.0 the program not run correct because all field of all table that were Timestamp are converted automatically in fields Datetime.
There is a solution for this problem or i can only use a BCP??
thanks and best Regards!!!byeeeeee byeeeeeeeeeeeeeeeeeeeeeeeee
September 24, 2002 at 4:42 am
September 24, 2002 at 6:45 am
hI,
THANKS FOR YOUR REPLY,
yes, if i use the DTS for import the DB the data Timestamp become a Datetime and i don't know if there are a solutions for this problem.
I think to use a BCP but my program are used in the world and the client can't execute it because it is dangerous and because the tables are a lot of and contain many data .while if it is possible to use the DTS the clients could execute it.
Thanks!!!byeeeeeeeeeeeeeeeee
ps:sorry for my English :-)))))))))
September 24, 2002 at 9:11 am
Maybe just build a batch file to do the bcp for them? Other than that, you should be able to modify the data types when you use DTS for the import.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply