Here's some links to resources to get you started:
TechEd Online Panel:
Go to
http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and
search for:
"Are we there yet? Successfully navigating the bumpy road from Access
to SQL Server"
Microsoft Access or SQL Server 2005: What's Right in Your
Organization?
http://www.microsoft.com/sql/solutions/migration/access/sql-or-access.mspx
Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx
What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspfaq.com/what-are-the-main-difference...etween-
"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
SQL Server Migration Assistant for Access (SSMA for Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
FMS Upsizing Center
http://www.fmsinc.com/Consulting/sqlupsizedocs.aspx
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446
--Mary
On Wed, 15 Oct 2008 11:57:03 -0700, Hasi
wrote:
>Hi Guys,
>
>I am trying to use Upsizing tool to convert Access 97 database to SQl server.
>
>Can anyone help in this aspect?
>
>Any help is appreciated...
>
>
>Thanks,
>Hasi