Stephen - when you mentioned this Logging thing (which, I'm assuming that SQL write a Log record for each record inserted - which we really don't need to do when we are just converting data) - you are referring only to the conversion process that I attempted to do. Right?
But, as I mentioned previously - I used the Import/Export Wizard tool of SQL - and I already got it to work and properly convert the data from VFP to SQL. Well, actually, I'm going to start comparing the actual data now - just to see if there were any problems with the conversion. However, if I am creating a program to convert the data - I should NOT have to worry about turning off logging of Inserts! Correct? -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Tuesday, May 15, 2012 3:19 PM On Tue, May 15, 2012 at 1:23 PM, Rafael Copquin <[email protected]> wrote: > At the risk of joining this thread a bit late, I would suggest you use > varchar(MAX) for memo fields, available only in SQL Server 2008. With > previous versions (ie 2005), use varchar(8000). When you convert data > from a VFP table, including a memo field, into a SQL Server table, use > this construct: In SQL Server do this first: USE [master] GO ALTER DATABASE [Your DB name here] SET RECOVERY SIMPLE WITH NO_WAIT GO This will stop logging all inserts to the log file while you are doing this: To reset logging USE [master] GO ALTER DATABASE [Your DB name here] SET RECOVERY FULL WITH NO_WAIT GO _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a140e260...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
