Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - To covert MS Access to SQLServer
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

To covert MS Access to SQLServer

 Post Reply Post Reply Page  <123
Author
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3938
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 30 June 2004 at 4:59pm
lol - I meant to say "My" bad - not "By bad"

Lead me not into temptation... I know the short cut, follow me.
Back to Top
michael View Drop Down
Moderator Group
Moderator Group
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4671
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 30 June 2004 at 11:03pm
Originally posted by Mart Mart wrote:

P.s. DSN connections are slower than DSN-Less connections
 
That is actually an untrue and way to general statement. A Programmer in my company proved me, that a ODBC connection from a COM Component, under certain circumstances, was 4.3x faster then ADO, ADOX or ADO.net. Basically I am just saying, you cannot generalize that, thus in the "web-world" is just easier to use something that does not require something done on the server.
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3938
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2004 at 1:59am

I prefer dsn-less connections though for maintainability. Seems that periodically you get the need to move hosts or servers or something. I structure db dsnless connections, mail server info, etc. in a config file so I can make all my changes in one place and they take immediately. A lot of hosts need you to go through them to set up dsn's which is a real pain.

But like michael said, circumstances vary. Depending upon what's happening in your world, one method may be better than another. For example, the Oracle 7 ODBC stuff was great, their 8i stuff was crap, and their 9+ stuff is good.


Lead me not into temptation... I know the short cut, follow me.
Back to Top
padoxky View Drop Down
Groupie
Groupie
Avatar

Joined: 17 June 2004
Location: Nigeria
Status: Offline
Points: 78
Post Options Post Options   Thanks (0) Thanks(0)   Quote padoxky Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2004 at 4:26am

Hosting  Oracle DB is costly than SQL SERVER. I don't think I will use Oracle DB cox I can't afford it.

But it's nice to use it.

NgWebDesigns
Back to Top
edwards142 View Drop Down
Newbie
Newbie


Joined: 31 January 2018
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote edwards142 Quote  Post ReplyReply Direct Link To This Post Posted: 25 February 2020 at 7:46am

I have some easy fixes to migrate or convert Access database to SQL server. Few days back even I also haven’t such kind of ideas. But after searching a lot for the fixes I found this informative post on how to do this task in an easy and effortless way.

Before staring up the conversion of Access database to SQL server, make all these setups

Make backup of your database.

Check that if you have plenty of disk space on the device or not; in which you will have to keep your upsize database.

Allow permissions on the SQL Server database.

Add unique index to each access table that you have, before upsizing it.

Check out the complete steps to convert Access database to SQL server from this post.

www.accessrepairnrecovery.com/blog/convert-or-migrate-access-database-to-sql-server




Edited by edwards142 - 25 February 2020 at 7:59am
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9616
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 25 February 2020 at 10:36am
Thank you for joining the discussion edwards142.

This topic is from 16 years ago, so I have a feeling that your reply maybe a little late as a solution for those forum members who posted in this topic.
Back to Top
 Post Reply Post Reply Page  <123
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.


Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Community Forums Web Wiz Blogs Web Wiz News
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

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 unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

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