JWColby
jwcolby at colbyconsulting.com
Fri Apr 27 19:28:39 CDT 2007
This is my development laptop. It is a 3 year old 3ghz AMD 64 (single core) with 2 gb of ram. The speed was reasonably fast although of course this is not a huge database, either in terms of number of tables, or number of records. I would say it took perhaps 30-60 seconds to do the whole database. Pretty fast IMHO. I will be trying it out on a big database at a client. One table that I really need to move has 250gb of data in a memo field. I'll keep you informed. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, April 27, 2007 8:16 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Moving your table to SQL Server 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com