[dba-VB] Moving your table to SQL Server

JWColby jwcolby at colbyconsulting.com
Fri Apr 27 18:45:34 CDT 2007


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




More information about the dba-VB mailing list