[AccessD] Moving your table to SQL Server

Dan Waters dwaters at usinternet.com
Fri Apr 27 19:16:19 CDT 2007


Hi John,

SSMA for Access is supposed to require 1 Gb of RAM to work.  Does your PC
have that much?

Did this take an appropriate amount of time?

Thanks,
Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Friday, April 27, 2007 6:46 PM
To: 'Martin'
Cc: dba-vb at databaseadvisors.com; 'Access Developers discussion and problem
solving'
Subject: Re: [AccessD] Moving your table to SQL Server

Martin,

Really it is just a matter of "how do you do it".  I am the kind of person
who needs to know the "how it is done" so that I can do it the next time.
In SQL Server 2005 Standard Edition there is a wizard that I use but it
pretty much sucks (at least how I have used it).  Data types are lost,
indexes are lost etc.

HOLY SMOKE batman!  I just ran the SQL Server Migration Assistant for Access
and it WORKED!  I imported my entire billing database into SQL Server
Express.  The wizard would not "find" the SQL Server Express database, but
if I typed it in "m6805\SQLExpress" it found it.  I went out there in
advance and created the database itself (no tables).  I am IMPRESSED!!!  I
am actually using my billing database hooked to SQL Server expressed now!

WOW!

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
 













































































































































































More information about the AccessD mailing list