Upgrade from Access to SQL

Post Reply

Page 12 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Topic: Upgrade from Access to SQL Posted: 13 December 2004 at 2:10pm
	I am currently using the access versionof 7.7a. I want to upgrade the database to MS SQL server. How do I upgrade the access files with the new version of the messageboard for SQL Server? Do I have to upgrade in access first, then upgrade into SQL? Your help is very much appreciated.
	Man Know Thyself

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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 version history, there are only a few files that require updating, no database work is required, to upgrade to the latest version.

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply 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?
	Man Know Thyself

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply 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 from datasource.. and select your old Access database and import the data from 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?

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply 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.
	Man Know Thyself

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply 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?
	Man Know Thyself

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 15 December 2004 at 11:04am
	dbo is best to have as the owner.. try entering a record manually into the database and see if its read in correctly, and also check that the records are in the table.

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply 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?
	Man Know Thyself

Post Reply	Page 12 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum