[AccessD] Database Conversion

[Jim Dettman]

 You can use the BullZip product or SSMA (SQL Server Migration Assistant).

 When you create the SQL tables, add a RowVersion field to every table ACE
will work with.

 That's a bare bones conversion, and you might be happy with that, but to
really get good performance out of SQL, you'll need to look at using
pass-through queries, stored procedures, views, and triggers.

There are a few fundamental tips here:

https://jstreettech.com/developer-downloads/

 as well in "The Best of Both Worlds: Access-SQL Server Optimization", to
get you started.

Jim.



-----Original Message-----
From: AccessD On Behalf Of Randall R Anthony via AccessD
Sent: Friday, January 5, 2024 3:33 PM
To: Database Advisors Group <accessd at databaseadvisors.com>
Cc: Randall R Anthony <RRANTHON at sentara.com>
Subject: [AccessD] Database Conversion

Hello Group,
Happy New Year!  I come before this august group with a question on
converting an Access DB to using SQL as the BE.  This is an ancient DB
(circa 2001, current v = 2013) that's bumping up against the 2GB wall.  It
uses a lot of macros in the processing logic.  How/what's the best way to
expedite converting to SQL tables?  I've seen a few posts back in the day
that used a SQL?  Access?  conversion tool with mixed results.  Thank you
for your time.

Regards,
R.






Disclaimer:


This electronic message and its contents and attachments contain information
from Sentara Health and is confidential or otherwise protected from
disclosure. The information is intended to be for the addressee only.

If you are not the addressee, any disclosure, copy, distribution or use of
the contents of this message is prohibited. If you have received this
electronic message in error, please notify us immediately and destroy the
original message and all copies.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com