Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Dump Access Database Layout		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

FixITguy
Starting Member

9 Posts
Posted - 21 April 2001 :  10:33:02  Show Profile
Hey,

I want to know if there is a way through ASP to dump a Access Database into a text file that can then be used to make a MS SQL database. If there is could someone please help.

Matt

PJamieson
Starting Member

United Kingdom
11 Posts
Posted - 21 April 2001 :  11:33:54  Show Profile  Visit PJamieson's Homepage
Data Transformation Services in MS SQL will import/copy/convert an Access database
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 21 April 2001 :  12:57:11  Show Profile
You have a number of options

Use DTS as PJamieson mentioned. This is available from SQL7 up.

Use the Access upsize wizard. A2K version is much more stable than A97. Works pretty well.

Export the data for your tables, create tables in SQL Server & use Bulk Insert or bcp to load the data. More work.



======
Doug G
======
Go to Top of Page

FixITguy
Starting Member

9 Posts
Posted - 21 April 2001 :  21:17:54  Show Profile
Thnx,

And if anyone else knows another way, please post it here.

Matt
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07