Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 How to setup database
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ashok
Starting Member

India
7 Posts

Posted - 20 May 2006 :  04:09:58  Show Profile  Send ashok a Yahoo! Message
hi

i want to shift my access db to sql server db,
is there any utility which creates db on sql server or should i import access db into sql server.

i am new user and i have not entered any data into access db. this is the default db provided by forum which i want to export into sql server.

if i create db there may little chance of typing mistake or wrong datatype.

so how should i setup sql server database for forum

thanks in advance
ashok kumar sharma

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 20 May 2006 :  04:15:51  Show Profile  Visit HuwR's Homepage
you should use the forums setup.asp to creat your SQL database, once youhave done that you can then import the data from your access db, do not attempt to just export your access db to sql, the forum will not work if you do
Go to Top of Page

ashok
Starting Member

India
7 Posts

Posted - 20 May 2006 :  04:43:46  Show Profile  Send ashok a Yahoo! Message
quote:
Originally posted by HuwR

you should use the forums setup.asp to creat your SQL database, once youhave done that you can then import the data from your access db, do not attempt to just export your access db to sql, the forum will not work if you do



thanks for reply and sorry for that repeat query
Go to Top of Page

ashok
Starting Member

India
7 Posts

Posted - 20 May 2006 :  04:54:48  Show Profile  Send ashok a Yahoo! Message
Thanks

i have setup db for sql server and it is working now

regards
ashok k sharma
india
Go to Top of Page

Carlos Miranda Levy
Starting Member

26 Posts

Posted - 27 June 2006 :  09:58:09  Show Profile
Why do you say it would not work?

I have just done that and it seems to work fine.

I upsized the .mdb database I was using to MS SQL with Access' built-in Upsizing Wizard. Then I just changed the connection string and it works just fine. I did not run Setup.

Should I re-do it doing the setup step and then importing the tables? Should I worry about something or can I call it a successful migration?


The forum with the access database is running at
http://www.educar.org/comun/foros

And the one with the MS SQL is running fine at:
http://www.educar.org/foros

(the only difference is that the SQL db is older, when I did the test migration)

quote:
Originally posted by HuwR

you should use the forums setup.asp to creat your SQL database, once youhave done that you can then import the data from your access db, do not attempt to just export your access db to sql, the forum will not work if you do


Edited by - Carlos Miranda Levy on 27 June 2006 10:00:15
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 27 June 2006 :  10:27:55  Show Profile  Visit AnonJr's Homepage
If I remember right, a lot of the indexes and defaults don't get setup right when you do it that way. I would probably recommend that you re-do it using the steps outlined. They explain it that way for a reason.

But if you want, wait a few more minuets and if ruirib hasn't already posted by the time I'm done typing this he'll be by with a second opinion shortly.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 27 June 2006 :  10:33:47  Show Profile  Send ruirib a Yahoo! Message
I've written so many times about this... I just recommend a search or a browse of the MS SQL Server forum. That will be enough to make a decision on what to do next.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Carlos Miranda Levy
Starting Member

26 Posts

Posted - 28 June 2006 :  07:08:30  Show Profile
ok, will do so.
thanks.

Here's the post that outlines the proper process:
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=31144


Edited by - Carlos Miranda Levy on 28 June 2006 07:17:48
Go to Top of Page

miniplayer
Starting Member

30 Posts

Posted - 07 July 2006 :  12:40:29  Show Profile
Is the setup program supposed to create the tables in my database or do I do that manually? All I see running is the insert script - where is create table tablename???

--- 5 minutes later --------------

Opps I forgot to swith db type from access to sql - work good now!

Edited by - miniplayer on 07 July 2006 13:00:01
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 July 2006 :  12:59:40  Show Profile  Send ruirib a Yahoo! Message
That's a permissions problem. Try a search for 'updateable query' and you will see many posts with recomendations on what to do.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

miniplayer
Starting Member

30 Posts

Posted - 07 July 2006 :  13:01:01  Show Profile
quote:
Originally posted by ruirib

That's a permissions problem. Try a search for 'updateable query' and you will see many posts with recomendations on what to do.



Got it - see above. I was going to use access but it was recommended here I should just stick w/sql...
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 July 2006 :  13:12:47  Show Profile  Send ruirib a Yahoo! Message
Ok, all is well when it ends well.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

miniplayer
Starting Member

30 Posts

Posted - 07 July 2006 :  19:10:12  Show Profile
quote:
Originally posted by ruirib

Ok, all is well when it ends well.



Interesting how well it works. I was never able to get rid of the "Missing Activation Key" error message when someone clicks the email link. All they needed to do is log on after getting the error and they would be moved to the active member table.

Instead of living with the error message I changed it to "Happy text". So now instead of "Missing Activation Key", it says "Registration Successful!". Sounds much nicer I think!

Thanks everyone for a great first forum experience. http://www.miniplayer.info/forum/

!
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 July 2006 :  20:30:29  Show Profile  Send ruirib a Yahoo! Message
I can't understand that. There is no reason the missing activation key error, I have no memory of such a persisting situation with the thousands of users of our code.

Is this a brand new forum?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07