Converting Access to MSSQL

Discussion in 'Database Support' started by jhoelz, Jan 30, 2004.

  1. jhoelz

    jhoelz Perch

    I'm running invision portal v3 and currently use an Access database. Since moving my site here I would like to convert that db to MSSQL.

    I have created my database and can run the SQL install script, but how do I convert the access db over?

    Do I use the SQL install with the portal 1st, then upsize and move everything over using access and the upsizing wizard?

    Do I upsize and move the tables 1st then run the SQL install?

    Thanks for your help.
  2. Yash

    Yash Bass

    this is best asked at aspinvision

    if you want help upsizing, you can let us know

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services