Converting from Access to MS SQL Server



Hello Everyone,
What sort of issues arise when converting a database from Access to MS SQL
Server? I know nothing of the latter, but this issue has come up where I work,
because the company wants to take some legacy Access databases and move them to
the MS SQL Server system. Some of these databases are, well, let's just say that
they were not put together in as skillful a manner as one would wish. (In fact,
I have looked at the structure of a couple of them and there are some hack jobs
out there.) Are there specific features or techniques used in Access that make
the process of conversion difficult? Are there reliable sources of information
on line?
Thank you,
-plh


--
Where are we going and why am I in this HAND BASKET??
.



Relevant Pages

  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: BizTalk Server 2004 ConfigFramework.exe error
    ... one BizTalk is installed on? ... machines (both for SQL and DTC) is not blocked by firewalls and new MSDTC ... Multi-computer configuration using Windows Server 2003 or Windows XP ... >>all associated databases. ...
    (microsoft.public.biztalk.general)
  • Re: What Database model should I use?
    ... If you want to upgrade to a serious DBMS you did not list SQL Server. ... Porting Access/JET databases can be done with the upsizing wizard as ... I would also read about coding ADO a bit more. ... > But I am having a problem converting the MS Access JET databases. ...
    (microsoft.public.vb.database)
  • RE: Clustering a standalone SQL server + storage array
    ... working as expected with out error your ready to install sql server. ... log files to the data and log shared drives you setup as part of the cluster. ... Our apps team look after a trading system that uses an HP DL360 server ... running SQL 2000 SP3a with a few small databases on it. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including the ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)