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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-15 : 10:31:10
|
| yazterfari writes "Is there a method or a wizard that allows you to converts an MS Access DB (with objects) to a SQL Server 2000 DB." |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-05-15 : 10:49:37
|
| If you are using Access 2000 then there is a database upsizing utility. I am not sure about Access 97.Jeremy |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-15 : 10:50:36
|
| Yes, it's called the Upsize to SQL Server wizard, it is built into Access 2000 and higher, it's on the Tools:Database Utilities menu.If you have Access 97, you can search http://www.microsoft.com/ for "SQL Upsize Wizard" and you can download and install it.It's very easy to use and transfers everything, including cascade delete/updates. However, it DOES NOT import queries, forms, or reports, because these do not exist in SQL Server. SQL Server views are similar to Access queries, but they are not exactly the same, and there are differences between Access SQL and SQL Server T-SQL. You will have to rewrite your queries in T-SQL, and you are better off anyway, since it offers features that Access does not. |
|
|
|
|
|
|
|
|
ms access / sql2k