Change MDB to SQL

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Change MDB to SQL

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Change MDB to SQL

Page: [1]


wizard_oz Posts: 140 Joined: 9/3/2004 From: Ga,USA Status: offline	Change MDB to SQL - 9/26/2006 5:35:54 Hi, I have a database which I created in ACCESS (mdb file) and I call to the file lije that:conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\webspace\disk20\david-poem.com\david-poem.com\db\magenli.mdb" I would like to chnage it to SQL server my question is: 1. how do I do it 2. Do I need to change my command line the (conn.open.....) thanks, Elen


Spooky Posts: 26599 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Change MDB to SQL - 9/27/2006 15:27:13 SQL has an upsizing wizard that can be used, but the design it chooses for you could be slightly different than you require. Typically programs come with an sql file that will create the tables / design for you. Then its a case of importing the existing records. You can normally just change the connection string to open the SQL database, but there may be a few small things (such as date handling) that needs to be modified _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to wizard_oz)