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