Using InfinityQS and moving from MS Access to MS SQL db

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Using InfinityQS and moving from MS Access to MS SQL db

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-07 : 07:19:49

Eileen writes "Tried variables in search but did not find anything to match.

Looking for any information if you have actually experienced moving data from MS Access to Sequal Server.

Reason: Only have Access now but company plans on purchasing Sequal. Want a heads up if there will be ANY issues/concerns before I start the project."

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-06-07 : 13:13:22

Been their done that. SQL

1. Rewrite your queries as stored procidures.
2. Do not let forms or reports access your tables directly write a procedure to do it.
3. Watch your naming avoid spaces in table or Procedure names.
4. Do not use select * for anything.
5. Learn to use pass through parameters and temporary tables.
6. Use cursors or loops only if someone sticks a gun to your head.

Jim
Users <> Logic

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-06-07 : 13:27:06

Keep in mind that Access and SQL Server actually do not have very much in common except that they both are database engines; they really are completely different beasts and there are actually many user interface things you can do in Access that requires additional tools in SQL Server, since SQL Server is a database engine and not a client tool.


                  Access     SQL Server
                  ------     ----------
Forms (UI)          X            -
Reports             X            -
VBA                 X            -
Database Engine     X            X
Server Application  -            X
Client Application  X            -

- Jeff

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-06-07 : 13:36:50

If you use .adp you can still use access on the front end and SQL on the back end.
The best of both worlds.

Jim
Users <> Logic

rishysingh
Starting Member

4 Posts

Posted - 2005-06-29 : 15:59:36

This is exactly i am looking for. To start we have a many MS Access databases. Now we are trying to upgrade the tables to sql server and still use MS Access as a frontend using .adp.

Can any one please advise the following (i am a newbie hence pardon for any unreasonable question)
1. the best way to move the tables/queries to the sql server. (i tried through DTS but do not know how to use DTS for transfering queries. If we move the tables and queries and keep the forms and reports in MS Access as front end.

2. Most of the tables in our MS Access databases are linked tables. Our mgt do not want it any more. Is there anyway i can update the data everyday with out linking the tables to excel download.

Your help is highly appreciated.

Raj

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources