Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Import database directly into sqlserver
Tue, Sep 7 2010 11:31 AMPermanent Link

dan r

na

Hi

Is there a quick way of importing a whole dbisam dbase into sql server?

The import data option under tasks(using the odbc)  will only let me import 1 table at a time.

thanks
Wed, Sep 8 2010 10:55 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dan,

<< Is there a quick way of importing a whole dbisam dbase into sql server?
The import data option under tasks(using the odbc)  will only let me import
1 table at a time. >>

I'm pretty sure that you can do so by using a DTS (Data Transformation
Services) package:

http://technet.microsoft.com/en-us/library/cc917688.aspx

--
Tim Young
Elevate Software
www.elevatesoft.com
Image