Change MDB to SQL (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

wizard_oz -> 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 -> 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



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
6.298828E-02