| Author |
 Topic Search  Topic Options
|
Nathan 
Groupie
Joined: 08 January 2002
Location: Greece
Status: Offline
Points: 160
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Upsizing Access db to SQL
Posted: 25 March 2003 at 11:52am |
|
I have been having problems with my forum as it keeps 'jamming' the server. (I'm with GH). I feel this might have a problem with the size of the access db and the amount of visitors.
SO I have setup a 'test' forum running on SQL - works perfect, but of course I would like to transfer my current access db to the SQL one.
I have been playing with the MS access upsizing thing over the weekend.
Now on the upsizing wizard, I am now trying using the create 'new database' option. then entering:
63.123.144.6 (SQL server)
and my username and password (as setup in the GearHost iControl panel)
Then it asks which tables to export. I select all of them.
Then I get a whole load of options for table atributes (some already selected) : not sure what to do here.
If I just press next, then it asks if I wish to modify the existing application or make a new one (I dont know what to select here either)
Then I select finish, it says upsizing and then after a few seconds I get the error report saying that Table was skipped or export failed!
Not sure where I am going wrong.
Please help someone.
Thanks
Nathan, Corfu Greece |
|
 |
Bluefrog
Senior Member
Joined: 23 October 2002
Location: Korea, South
Status: Offline
Points: 1701
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 March 2003 at 8:43am |
|
Not sure, but try going about it from the opposite direction. Import it from SQL Server instead. That should work better.
|
|
somy
Newbie
Joined: 05 April 2003
Location: Egypt
Status: Offline
Points: 22
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 April 2003 at 5:12am |
|
so how to transfer from v7... to Sql database without loosing dat??
|
|
the boss
Senior Member
Joined: 19 January 2003
Location: Saudi Arabia
Status: Offline
Points: 1727
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 April 2003 at 6:55am |
|
try using the acces upsizing wizard or export acess DB to CSV and then import it into SQL.. i can gurantee wether your data will be preserved or not...
|
|
Joey805
Groupie
Joined: 24 November 2003
Location: United States
Status: Offline
Points: 92
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 December 2003 at 4:43pm |
I am having the same problems. When I import the MDB file To SQl it works successfully if I dont run the msSQL_server_setup.asp file. However if I don't run it, not all the SP's and tables get created. Either way I cant win. Is there anyone that can help me out here?
|
|
Flamewave
Senior Member
Joined: 19 June 2002
Location: United States
Status: Offline
Points: 376
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 December 2003 at 12:19pm |
If you have MS SQL Enterprise Manager, you can do this:
Run the sql setup file and get a valid empty MS SQL database created. Once this is done, right-click on the database, goto "all tasks" and "import data". For the datasource, choose Microsoft Access, then point it to the right db file on your hard drive and enter the appropiate information. Make sure the destination db and tables are right, and then import the data.
|
|
- Flamewave
They say the grass is greener on the other side, but if you really think about it, the grass is greener on both sides.
|
|
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 February 2004 at 5:57pm |
i know this is an old topic
but i did a search on google about this
and ive figured it out
you have to choose "no application changes"
this will acctually upload it, since the other options seem to be mearly linking SQL to Access 
anyway just thought i might post this incase anyone searchs the forum or its needed
|
|
|
|
