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
 upsizing wizard

Author  Topic 

-Dman100-
Posting Yak Master

210 Posts

Posted - 2004-02-16 : 10:38:02
I have several small web applications that use an Access database. A few of the applications are nearing a point to migrate over to a more robust database...i.e. SQL Server. For the most part, most of the databases are very simple. One or two tables used for logins, setting access permissions, collecting data from forms, etc. Some of the tables have relationships, but no stored procedures or advanced query strings. Very basic and simple DB's.

Can you use the upsizing wizard or any other method to move to a SQL Server DB? If so, can anyone direct me to any tutorials or information on moving an Access DB to MS SQL Server? Any help is appreciated. Thanks in advance.
-Dman100-

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2004-02-23 : 07:41:34
have a read of this post..

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=29432&SearchTerms=moving,an,access,db,to,sql,server


====
Paul
Go to Top of Page
   

- Advertisement -