|
|
Posted by NickName on 06/22/06 18:04
This question probably has been asked many a time. And yet I feel it
is still relevant for one thing a search on this NG does not produce a
desirable answer.
It is kind of disappointing that MS would not be able to transfer ER
relationship from an Access db to a SQL Server 7/2000-based one, the
upgraded db/imported tables sitting on the SQL Server would not have
PKs, say, you have 100 user tables, you have to first recreate PKs for
each of them then set up relationship between/among them, quite time
consuming. Do you have a better way?
Along the same line of the task, what options out there for converting
Access Modules into SQL Server-based Stored Procedures and/or UDFs?
The manual option is sure there, third party tool? I wouldn't trust
them that much though.
TIA.
Navigation:
[Reply to this message]
|