Web Wiz Support and Community Forums : Upgrade from Access to SQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 21:07:04 +0000 Wed, 15 Dec 2004 12:18:28 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12968 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Upgrade from Access to SQL : I am also going step by step of...]]> https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71933.html#71933 Author: imhotep
Subject: 12968
Posted: 15 December 2004 at 12:18pm

I am also going step by step of the process of the "Access to SQL Server - Step by Step" thread, and when it is doing its conversion, on all of the "Drop Table" steps, it is throwing an error. Any possible reasons?
 
  • I deleted all of the tables again
  • I ran the setup first this time
  • Now I am importing the tables
  • throwing error message on drop steps
 
]]> Wed, 15 Dec 2004 12:18:28 +0000 https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71933.html#71933 <![CDATA[Upgrade from Access to SQL : I really am lost here. I don&#039;t...]]> https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71928.html#71928 Author: imhotep
Subject: 12968
Posted: 15 December 2004 at 11:37am

I really am lost here. I don't see a way just to import the data into the tables that are already owned by "dbo." Is there a way to login as the "dbo" instead of the "mochasuite," that way the files "might" override the existing "dbo" tables?
 
What are the steps in just uploading the data into the "dbo" structure?
 
 
]]> Wed, 15 Dec 2004 11:37:36 +0000 https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71928.html#71928 <![CDATA[Upgrade from Access to SQL : select import and select the other...]]> https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71924.html#71924 Author: dj air
Subject: 12968
Posted: 15 December 2004 at 11:20am

select import and select the other tables details to the import details i think you can send just content not structure.

IE make the tables details for mochasuite the import tables into the dbo ones.]]> Wed, 15 Dec 2004 11:20:49 +0000 https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71924.html#71924 <![CDATA[Upgrade from Access to SQL : The tables owned by mochasuite...]]> https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71921.html#71921 Author: imhotep
Subject: 12968
Posted: 15 December 2004 at 11:10am

The tables owned by mochasuite have data in the tables. But the ones with "dbo" do not. Is there a way to transfer the information from the "mochasuite" owned tables to the "dbo" owned tables?]]> Wed, 15 Dec 2004 11:10:28 +0000 https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71921.html#71921 <![CDATA[Upgrade from Access to SQL : dbo is best to have as the owner.....]]> https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71919.html#71919 Author: dj air
Subject: 12968
Posted: 15 December 2004 at 11:04am

dbo is best to have as the owner.. try entering a record manually intothe database and see if its read in correctly, and also check that therecords are in the table.]]> Wed, 15 Dec 2004 11:04:47 +0000 https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71919.html#71919 <![CDATA[Upgrade from Access to SQL : Experimenting Also, when I...]]> https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71918.html#71918 Author: imhotep
Subject: 12968
Posted: 15 December 2004 at 10:55am

Experimenting
 
Also, when I deleted the tables and imported the tables from access, then nothing displayed on the Default.asp page. But when I go through MSSQL_Server_Setup.asp, the pages show, but still does not show the database content.
 
Also, I noticed in the SQL Enterprise Manager that when I import, there are two sets of Tables: One owned by "dbo" and the other "mochasuite"
 
Mochasuite is the name of the website domain.
 
Could this be a clue? I can tell that when the tables are simply owned by "mochasuite," that nothing shows up. But when owned by "dbo" the pages come up, but there is no data. What could I be doing wrong? Are the tables that different in structure that it needs to create a seperate set of tables owned by a different entity? Or is there a way to override and copy over the "dbo" owned tables with the information from the access database?
]]> Wed, 15 Dec 2004 10:55:16 +0000 https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71918.html#71918 <![CDATA[Upgrade from Access to SQL : I did the normal set-up to add...]]> https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71916.html#71916 Author: imhotep
Subject: 12968
Posted: 15 December 2004 at 10:33am

I did the normal set-up to add the tables to the SQL Server from the setup file. Then I imported the (did not upsize from access) the data and structure from the SQl Server.
 
Since that didn't work, I deleted all of the tables and I am re-importing them again through SQL Server and I am awaiting the results as I type.
]]> Wed, 15 Dec 2004 10:33:00 +0000 https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71916.html#71916 <![CDATA[Upgrade from Access to SQL : open the SQL database (with which...]]> https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71915.html#71915 Author: dj air
Subject: 12968
Posted: 15 December 2004 at 10:29am

open the SQL database (with which ever way you do)

and check if the data is there correctly,

you can always delete the content if not correct and select import fromdatasource.. and select your old Access database and import the datafrom the old database.

sorry just seen the last part of your post . Did you import or Up size the database to SQL.

IE did you have to create the tables from the MSSQL_Server_Setup.asp file or upsized and then it was there?
]]> Wed, 15 Dec 2004 10:29:33 +0000 https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71915.html#71915 <![CDATA[Upgrade from Access to SQL : I imported the access database...]]> https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71914.html#71914 Author: imhotep
Subject: 12968
Posted: 15 December 2004 at 9:55am

I imported the access database to the SQl Server, and in the admin section, it seems like it is reading the tables, but when I actually go to the forum, the tables don't display and there are no records. What could be the problem?]]> Wed, 15 Dec 2004 09:55:21 +0000 https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71914.html#71914 <![CDATA[Upgrade from Access to SQL : please do a search on this as...]]> https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71785.html#71785 Author: dj air
Subject: 12968
Posted: 13 December 2004 at 6:00pm

please do a search on this as there are many ways to upgrade to SQL,

regards to updating access 7.7a to 7.9 please check the versionhistory, there are only a few files that require updating, no databasework is required, to upgrade to the latest version.
]]> Mon, 13 Dec 2004 18:00:12 +0000 https://forums.webwiz.net/upgrade-from-access-to-sql_topic12968_post71785.html#71785