|
|
Posted by Erland Sommarskog on 02/03/07 23:17
Jonathan Roberts (gremln007@diynics.com) writes:
> Wes Groleau wrote:
>> When I try to import from Access, the DTS wizard only allows me to
>> import tables and queries. OK, I'm not surprised the "macros" and
>> reports don't come over.
>>
>> But it executes each query, and created a _table_ to hold the results.
>>
>> The sensible thing would be that SELECT queries become views
>> and the others become stored procedures. But I find no way
>> controls I can select to do that.
>>
>> I have to manually create the views/procedures and paste in the SQL.
>> And then I still have to translate it into standard SQL.
>>
>
> Have you tried using the Upsize wizard?
I have never worked with Access myself, but from people that hold
expertise in both Access and SQL Server, I have heard strong recommendations
of staying away from the wizard.
Migrating from Access to SQL Server is quite an undertaking, and there
are many differences. Not the least since Access since is more or less
all-in-one, while with SQL Server you get a client/server setup.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|