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 |
|
BlueBell
Starting Member
4 Posts |
 Posted - 2013-12-18 : 08:11:57
|
| I have upsized an access database and one table uses a lot of lookup fields from other tables. During upsizing the link between these was lost. Is there something I should do during the upsizing process to ensure that the original link remain. For example, do I need to process the various tables in a certain order in order for the data to remain sound Many thanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-12-18 : 10:20:14
|
Not sure how you performed the "upsize" but relationships between tables (links) are accomplished in sql server by adding Foreign Key constraints.for instance suppose you have an address table and you want to link the addresstypeid to an addresstype lookup table:alter table Address add constraint FK_Address_AddressType foreign key (addressTypeID) references AddressType (addressTypeID) Be One with the OptimizerTG |
 |
|
|
|
|
|
lookup fields