Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Need to upgrade an Access db to MSSQL?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Need to upgrade an Access db to MSSQL?
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
JohnKn View Drop Down
Groupie
Groupie


Joined: 22 March 2003
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote JohnKn Quote  Post ReplyReply Direct Link To This Post Posted: 29 August 2004 at 10:26pm
Sorry for taking so long to get back to you, I didn't get the topic notification and then couldn't login. I'm still interested, just let me know when you're ready to send over the script.
Back to Top
Seba View Drop Down
Newbie
Newbie


Joined: 15 September 2004
Status: Offline
Points: 1 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Seba Quote  Post ReplyReply Direct Link To This Post Posted: 15 September 2004 at 3:32am
I'm interesed to test script. Where i can found it?
Back to Top
fastfred View Drop Down
Groupie
Groupie


Joined: 10 December 2002
Location: Netherlands
Status: Offline
Points: 78 		Post Options Post Options   Thanks (0) Thanks(0)   Quote fastfred Quote  Post ReplyReply Direct Link To This Post Posted: 15 September 2004 at 9:28am

I do have a 35 Mb MsAcces database.

Right now i don't have the time for changnig to SQL (and the extra costs of hosting).

If you have a place (send me a PM) where i can upload the database i might can help you i you want.
   
Back to Top
Bluefrog View Drop Down
Senior Member
Senior Member


Joined: 23 October 2002
Location: Korea, South
Status: Offline
Points: 1701 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bluefrog Quote  Post ReplyReply Direct Link To This Post Posted: 15 September 2004 at 10:47am
I'm curious as to why this would be needed when DTS works perfectly well.
Renegade Minds - Guitar Software Slow Down Music
Back to Top
JohnKn View Drop Down
Groupie
Groupie


Joined: 22 March 2003
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote JohnKn Quote  Post ReplyReply Direct Link To This Post Posted: 15 September 2004 at 11:13am
DTS works for getting the data into the db if you have Enterprise Manager, but it leaves several columns that need to be manually changed. Things like the following are not correctly set by DTS:

tblTopic:  Topic_id - identity set to Yes, Identity Seed = last id
tblTopic: moved_id - default value = 0
tblTopic: No_of_views - default value = 0
tblTopic: Locked - default value = 0
tblThread: Thread_id - identity set to Yes, Identity Seed = last id
tblAuthor: Author_ID - identity set to Yes, Identity Seed = last id
tblAuthor: No_of_posts - default value = 0
tblBanList: Ban_ID - identity set to Yes, Identity Seed = last id
tblCategory: Cat_ID - identity set to Yes, Identity Seed = last id
tblPMMessage: PM_ID - identity set to Yes, Identity Seed = last id
tblPoll: Poll_id - identity set to Yes, Identity Seed = last id
tblPollChoice: Choice_ID - identity set to Yes, Identity Seed = last id
tblSmut: ID_no - identity set to Yes, Identity Seed = last id
tblForum: Forum_id - identity set to Yes, Identity Seed = last id

It's not difficult to manually do it, a bit tedious but it's not something you'd be doing often. If someone has a script to do it, why not use it?
Back to Top
Emiliano View Drop Down
Newbie
Newbie


Joined: 29 June 2004
Status: Offline
Points: 26 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Emiliano Quote  Post ReplyReply Direct Link To This Post Posted: 11 October 2004 at 2:03pm

I was reading this topic and thought: what if we make a very fresh new clean install of WWF on a MS-SQL database and then import our data from Access to it?

We could change some identity fields before importing and restore them as identity after. Maybe this way we do not have to set all those default values . ;-)

Think about it. I'll try to do it this week. :-)

Anyway, using a script would be much easier!!!

Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.