You are here: Re: Using DTS to migrate Access ot SQL Server « MsSQL Server « IT news, forums, messages
Re: Using DTS to migrate Access ot SQL Server

Posted by Jonathan Roberts on 02/04/07 04:14

Wes Groleau wrote:
> Jonathan Roberts wrote:
>> 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.
>>>
>>> [snip complaint details].
>>
>> Have you tried using the Upsize wizard?
>
> The upsize Wizard does not work. On the third or fourth
> page, it pops up a box saying nothing but "Overflow"
> Nothing happens in SQL Server.
>

Glad you mentioned it. You have hit the number one common problem with
the wizard. It does work but you have to overcome this issue. Google
it to find many pages of info. One KB is here:
http://support.microsoft.com/kb/272384. I don't remember the exact fix,
but it wasn't hard to resolve.

If you don't want to go that route, you can certainly pull out all your
queries manually and create views in SQL Server. I don't know of an
automated way to do this. If you have a lot of queries, this way may
not be practical.

Good luck and keep posting if you need help.

Jonathan

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация