RE: ASP - converting to SQL server

by "Brett Errington" <brett(at)opensearch.com>

 Date:  Thu, 25 Oct 2001 22:12:19 +0800
 To:  "'Klaas De Waele'" <klaas(at)gracegraphics.be>,
<hwg-techniques(at)hwg.org>
 In-Reply-To:  rudy
  todo: View Thread, Original
I've never done it... but I understand that it's not too difficult. One
method I know you could do (off the top of my head) is to export your
access db (it has numerous export functions) to something like a tabbed
text file or something that you have read that SQL can import. Just read
the help on both and find out what Access can export that SQL will
import. This is of course if you don't find a direct conversion
function/program.

Later,
Mr Brett
 
"That's a pain that will surely linger, and that's no lie"
- Ed Grimely

-----Original Message-----
From: owner-hwg-techniques(at)hwg.org [mailto:owner-hwg-techniques(at)hwg.org]
On Behalf Of rudy
Sent: Thursday, 25 October 2001 8:53 PM
To: Klaas De Waele; hwg-techniques(at)hwg.org
Subject: Re: ASP - converting to SQL server

> Just swap out ourfile.mdb with whatever.sql and change the pointers?

hi kayjey

nope, that would be too simple!!

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlma
g99
/html/steps.asp

http://support.microsoft.com/support/kb/articles/Q237/9/80.ASP

rudy

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA