Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jon3k
Starting Member
49 Posts |
 Posted - 2005-05-26 : 13:50:48
|
| When attempting to import a Foxpro database into sql, I ran into a problem with the date conversions. The DTS package insists on using a smalldate field. If I change that to a full datetime field, and import again, it works fine. However, I would really like to be able to select the datatype during the creation of the DTS package. How would I go about doing this? |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2005-05-27 : 09:25:05
|
| Information:===========datetime: Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.smalldatetime: Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute.This is the major difference in datetime and smalldatetime in sql server. I am not sure whether all the data types of foxpro will support in sql server 2000. Before you doing it please verify the compatible databases for both sides then start import the data.For more information about SQL Server goto books online and search for word "Data Types".With RegardsSreenivas Reddy B |
 |
|
|
|
|
|
|
|
Visual Fox Pro -> SQL (smalldate overflow)