October 1, 2002 at 9:34 am
I need to copy tables existing in dBase format into SQL Server. I planned on using DTS for the task. My question: Once moved into SQL Server, will the records be in the same sequential order that they were originally in (in dBase)?
October 1, 2002 at 9:48 am
Yes! Unless you managed to change the sort order of the dbase within the DTS. I've never seen the sort order change myself unless explicitly coded.
Clive Strong
October 1, 2002 at 9:51 am
That's great news. Thanks Clive.
October 1, 2002 at 10:09 am
The order of the records once they are in your sql server table(s) will depend on the clustered index, if you have any. All tables in sql server are ordered by the clustered index. Check Books On Line in sql server for more info (search under clustered index).
hth,
Michael
Michael Weiss
Michael Weiss
October 1, 2002 at 11:26 am
I know this is bad practice, but if I create a non-clustered index will it still change the order?
October 1, 2002 at 11:51 am
I dont believe the order will be changed if you do not have a clustered index on your table. Also, it isn't always bad practice to not have a clustered index...sometimes it makes sense not to have one...i just can't think of any examples off the top of my head...
hth,
Michael
Michael Weiss
Michael Weiss
October 2, 2002 at 3:53 am
You can store anything without a clustered index or any other index. However if you have a logical clustered index (unique or not) that fits the order of the dbase data it does in some cases save overall space.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply