| Author |
 Topic  |
|
|
lin
Starting Member
18 Posts |
 Posted - 03 July 2003 : 04:30:27
|
Hi
I currently use version 3.3.03 with an access database but I would like to use the latest version and keep all members. I don't have to keep the posts that have been made, but I do want to keep all the members.
Could this be done?
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
lin
Starting Member
18 Posts |
Posted - 03 July 2003 : 06:00:11
|
Hi Ruirib
When I try to upgrade my forum from the version I have to the latest everything but theese two is OK...
Error: 80040E37 Tabellen 'FORUM_MEMBERS_PENDING' doesn't exist.
strUpdateSql: DROP TABLE FORUM_MEMBERS_PENDING
Could you please advice me on how to proceed?
|
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
lin
Starting Member
18 Posts |
Posted - 05 July 2003 : 02:46:34
|
Hi
But when I look in the access database there are relations between the database tables, and when I look in the newly created tables with all the transfered data in the SQL database there are no relations and all the primary keys are missing. Why is that and how do I correct that? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
lin
Starting Member
18 Posts |
Posted - 05 July 2003 : 08:02:26
|
| No they are there in the Access database and everything works fine if I use the Access database. But when I use DTS to import the access database to the SQL server 2000 database there are no primary keys what so ever in any of the database tables..... |
|
|
|
lin
Starting Member
18 Posts |
Posted - 05 July 2003 : 08:22:07
|
I have set up the database and created all the database tables. I have also upgraded the Acces databas without problem.
My next thing to do is to use DTS to transfer all the current data into the newly created SQL Database.
So I wonder what settings of the one below I should use.
Transformation - Column Mapping
* Create destination table
* Delete rows in destination table
* Append rows to destination table
And there are two check boxes....
* Drop and recreate destination table
* Enable Identity insert
Regards
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 05 July 2003 : 15:55:51
|
You need to let Snitz create the new tables in the sql database, then use DTS to move just the data in the tables. DTS doesn't seem to be able to transfer primary keys, default values, and other indices/constraints between Access and SQL Server.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
lin
Starting Member
18 Posts |
Posted - 05 July 2003 : 17:16:45
|
Hi
Well I have allready let snitz create all the database tables, I wondered what of the settings below I should use.
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 05 July 2003 : 19:06:46
|
Identity Insert and Append Rows, I believe.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 July 2003 : 23:40:29
|
quote:
Originally posted by Doug G
Identity Insert and Append Rows, I believe.
Identity Insert, yes, but you should use Delete Rows instead of Append Rows, to delete the data created by Snitz during table creation.
Lin, this was clearly stated in the post about Access to SQL Server migration I posted a link to in my first post. Had you read it carefully, you'd see there would be no need to ask again. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
lin
Starting Member
18 Posts |
|
| |
Topic |
|
Topic Locked
