| Author |
 Topic Search  Topic Options
|
pedalcars 
Senior Member
Joined: 12 August 2002
Location: United Kingdom
Status: Offline
Points: 268
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Access / SQL differences
Posted: 25 April 2003 at 7:27am |
|
Couldn't find any previous reference to this, so:
I have a live v7 forum now, running on Access.
My friendly server owner has suggested moving to the SQL version, which I'm more than happy to do.
With the exception of the DB (naturally!) are there any differences between the distributions? If so, what? I don't want to start customising my installation now, if I have to replace all the pages when I move to SQL.
I see a lot of the .asp files have paired functions in (one for access, one for SQL) - does this mean there's just a single (or limited number of) files / variables one has to change?
Ta
|
|
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 April 2003 at 7:46am |
Just change one variable in the common.asp files and add your SQL srever login details into the SQL_server_Connection.asp file fopund in the admin area.
'Database Type
'strDatabaseType = "Access"
strDatabaseType = "SQLServer"
|
|
|
|
pedalcars
Senior Member
Joined: 12 August 2002
Location: United Kingdom
Status: Offline
Points: 268
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 April 2003 at 8:03am |
|
Fantastic, that's what I was hoping for. Top stuff.
|
|
|
|
neilcarter
Newbie
Joined: 25 August 2002
Location: United Kingdom
Status: Offline
Points: 10
|
Post Options
Thanks(0)
Quote Reply
Posted: 25 April 2003 at 1:52pm |
As the "friendly server owner" I thought I would give this a try. I have set up another copy of V7 on the server, created the database, and run the scripts to create the tabels etc. No problem I now have a working SQL version of the forum with no data.
I then tried to use DTS to move the data from the access database to SQL at it throws are3 large number of Violation of primary key errors. I would be grateful for any suggestions.
Neil
|
|
pedalcars
Senior Member
Joined: 12 August 2002
Location: United Kingdom
Status: Offline
Points: 268
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 April 2003 at 9:33am |
|
Ooh eck, that doesn't sound pretty...
Help, anyone? People must have done this before, although I guess the number of people who have migrated from v7 access to v7 SQL is going to be limited, v7 having only been out about a week!!
Ta
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 April 2003 at 10:58am |
Remove the database form the SQL server, then use the Access Upsize wizard to upsize the database choosing the option to create a new database on the SQL server and also make sure you arn't using a DSN with the upsize wizard otherwise it won't create the primary keys and default values.
|
|
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 April 2003 at 8:26am |
|
But if you use DTS make sure to enable identity insert in the transformation options...
|
|
|
|
