Database Discussion - upgrading to sql server

Print Page | Close Window

upgrading to sql server

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13480
Printed Date: 30 March 2026 at 4:19am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: upgrading to sql server

Posted By: netsonic
Subject: upgrading to sql server
Date Posted: 23 January 2005 at 11:25am

Hi all

i am upgrading my webwizforum access db to ms sql server version...but i have some problemss...

i directly use dts tool..source my computer access db and destination web host sql server...it successfully convert and upload it but i am not sure if it takes the relations on database to sql server?

also when i look under stored procedures i saw there is no procedures.
so when i try to open connect my forum it says internal server error...

is it because of no stored procedures? or what must i do exactly in order?

please help...

thankk you

Burak

Replies:

Posted By: dj air
Date Posted: 23 January 2005 at 11:29am

with out a more detailed error message.

i can assome its the stored procedures as they aren't in the Access version. you need to run the MSSQL+Server_setup.asp file to create the stored procedures. you will have to edit the file so it wont cause errors, when trying to create the tables, that already will exist.

there is a pinned topic within the support forums about upgrading to SQL from access

what Version are you using (V7.9?)

Posted By: netsonic
Date Posted: 23 January 2005 at 11:41am

yes exactly 7.9 version...

i have tried to run MSSQL+Server_setup.asp on an empty database then used dts tool to convert and upload my access db to sql...these time i had 2 duplicated tables from everyone...so it didnt worked again

these time if i use dts tool first then i run the MSSQL+Server_setup.asp file secondly ....does it work? what you think?

i couldnt try this before asking because my db is very big

thank you

Posted By: netsonic
Date Posted: 23 January 2005 at 12:09pm

in an old topic i saw this

""If you use dts to copy your tables make sure that you enable Identity insert in the table options.""

where is the table options i cannot find??

Posted By: dj air
Date Posted: 23 January 2005 at 1:30pm

im not sure about ""If you use dts to copy your tables make sure that you enable Identity insert in the table options.""

but if importing into a fresh database.

you need to delete the creation of tables, index, etc.. and only leave the stored procedures.

Posted By: michael
Date Posted: 23 January 2005 at 6:32pm

In a Nuthshell, like djair basically said, you create the empty db like you already did, run the setup file to have all tables and sp's. Then you import the tables using DTS in the right order meaning don't contradictforeign keys by i.e. importing forum groups before forums, go from bottom to top. In the DTS Wizard click on the Transform button and select 'Enable Identity Insert' and 'Delete rows in Destination Table' You may have to do more then one pass because DTS 8.0 does not let you sort the tables the way it's necessary.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: netsonic
Date Posted: 23 January 2005 at 11:47pm

Then you import the tables using DTS in the right order meaning don't contradictforeign keys by i.e. importing forum groups before forums, go from bottom to top.

thanks a lot but i didnt understand clearly what you mean here?which tables i must import first?

and also when i tried only the group table to import...ihve choosen identity insert and delete rows etc...it gave this error...

'DELETE statement conflicted with COLUMN REFERENCE constraint tblAUTHORFK_00'

Posted By: netsonic
Date Posted: 24 January 2005 at 12:14am

and for the author table it says this error....

'INSERT STATEMENT conflicted with COLUMN FOREIGN KEY constraint tblAUTHOR_FK00

i am doing a common and mistake i think but its the first time i am related with SQL...i am sorry ...thanks for helping mee

Posted By: michael
Date Posted: 24 January 2005 at 1:06pm

Well what I ment with the statement was actually exactly the problem you indicate... You cannot import data from a table that has a FK before you import the PK's table.

So essentially what I'd do first, is import the tables that don't have relationships:
tblBanList
tblConfiguration
tblDateTimeFormat
tblSmut

After that import the User Related Tables:

tblGroup

tblAuthor

tblPMMessage

tblEmailNotify

tblBuddyList

Last you can import the forum tables

tblCategory

tblForum

tblPermissions

tblTopic

tblThread

tblGuestName

tblPoll

tblPollChoice

I know it's a pain, as you cannot really tell DTS the order you want to do things in (unless you do your own package) but that is the way to do it.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: netsonic
Date Posted: 25 January 2005 at 1:41am

Thank you very much i ve solved the problem based on your information....

thanks again