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 |
|
na2173
Starting Member
38 Posts |
 Posted - 2002-08-12 : 13:30:23
|
| hiI am in one of the conversion project from fox pro to SQL Server, the company uses Foxpro database in various different locations , all the table structure same, i have to convert the foxpro database into one single sql server database, All the primary keys, foreign keys are int and for each of the database it starts with the same key no for example if a table a have a primary key starting from 1000 the same table for different location will also have primary keys starting from 1000i thought of one idea is that instead of using int as keys i will use charaters so when i move the data into sql server, i will always prefix with the location and then the keyno For exampleIf i am moving data from Say Newyork i will prefix with NY + Primary key table value, that way all the values in different tables will be same.If you know any more good ideas, please let me know |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-08-13 : 12:05:11
|
| My suggestion is that the row in your SQL Server table have a column for location and a column for the int. Then use a a composite key of location and int column for the primary key.In general, its not a good idea to combine char and int data into a single column.HTHs solart |
 |
|
|
|
|
|
Converting Foxpro databases to Sql server