Hi,
was wondering if soe one could give me some advice.
We are in the process of migrating an MS Access database to SQL server and wish to consolidate some of the Access Code into SQL Stored Procedures. Im a DBA with plenty of SQL Server experience but very little on Access. From the Client server point of view (which I am Use to , it just makes more sense).
Yes,
I already know about the migration tool (SSMA) to do this but just making link tables only does half the job as far as I am concerned. There are more efficiencies to be gained with a High level Server doing most of the work for intensive Reports and some of the Access List Population rather than denornmalising the Datbase just to have specific tables for access population, ( which the originial designers have done to get around the Spped problesm encountered ).
Question is:
I dont wish to ODBC,
but rather the more efficient SQL OLEDB through ADO calls.
Does anybody have any Good Articles or Books that would help me with this.??? I've had enough of reading migration articles but they always seem to stop short of the mark in taking that final step forward in migration fully into SQL Server.
I have thought about the Access Project but I believe that this should be steered away from now days as it isnt supported??( Am I missing the boat here on this one??)
Input / discussion greatly Appreciated.
cheers
Mike