Hi,

Currently we have a VB6 program that accesses an access
database through odbc. We would like to migrate the data
to SQL server 2000, but it isn't done overnight. We would
like to be able to go back to access in a reasonable time
if something is overlooked. Since we also should be able
to go to oracle we started putting the database layout in
an Erwin File.
A forward engineer works fine for the tables and
relations, but not for the views. Is there an easy way to
do that? Now I just copy paste and alter it a bit (create
view...).
Another question about data import. We have a small
program in access which puts the data in SQL server but
that takes days! There are 6 or 7 table swhich really take
long. I can use the import utility in sql server which
works a lot faster, but I have to take the order
(constraints etc.) in account.
Is there a way in SQL server to specify teh order it
imports the tables? (instead of alphabetically).

Thank you,
Arvid Mestdagh

Report this post to a moderator

> Is there a way in SQL server to specify teh order it
> imports the tables? (instead of alphabetically).

Yes, control of flow in DTS packages

Report this post to a moderator

Hello Arvid,

As Jacek has pointed out , DTS can serve you purpose . Use Copy table and
Views radio button while xfer.

Thanks,

Vikrant Dalwale

Microsoft SQL Server Support Professional

This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure ! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.

--------------------
>Content-Class: urn:content-classes:message
>From: "Arvid.Mestdagh" <am@cipal.be>
>Sender: "Arvid.Mestdagh" <am@cipal.be>
>Subject: migrate from access2000 to SQL server
>Date: Tue, 6 Aug 2002 02:52:50 -0700
>Lines: 24
>Message-ID: < 11c601c23d2f$06cab3a0$3aef2ecf
@TKMSFTNGXA09>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcI9LwbIOhh+6M4pTsiluwPFUheBHA
==
>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa08
>Xref: cpmsftngxa08 microsoft.public.sqlserver.server:222938
>NNTP-Posting-Host: TKMSFTNGXA09 10.201.226.37
>X-Tomcat-NG: microsoft.public.sqlserver.server
>
>Hi,
>
>Currently we have a VB6 program that accesses an access
>database through odbc. We would like to migrate the data
>to SQL server 2000, but it isn't done overnight. We would
>like to be able to go back to access in a reasonable time
>if something is overlooked. Since we also should be able
>to go to oracle we started putting the database layout in
>an Erwin File.
>A forward engineer works fine for the tables and
>relations, but not for the views. Is there an easy way to
>do that? Now I just copy paste and alter it a bit (create
>view...).
>Another question about data import. We have a small
>program in access which puts the data in SQL server but
>that takes days! There are 6 or 7 table swhich really take
>long. I can use the import utility in sql server which
>works a lot faster, but I have to take the order
>(constraints etc.) in account.
>Is there a way in SQL server to specify teh order it
>imports the tables? (instead of alphabetically).
>
>Thank you,
>Arvid Mestdagh
>

Report this post to a moderator