How export SQL2005 as DB4

We need to set up a nighly process that exprts the data in SQL 2005 to a DB4 format. I can't seem to find a provider or any infomation on how to do so.
dmoss123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LowfatspreadCommented:
what do you mean by db4?

aswuming its db2 for which platform/OS are we going to be dealing with and
wihc version of db2/udb?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kent OlsenData Warehouse Architect / DBACommented:
Hi dmoss123,

DB4?

This is a DB2 forum, for discussing IBM's DB2/UDB databases.  If you need Db2 help, ping back and we'll help you out.

If you really want DB4 assistance, post the question (or have the moderators move it) to the linux and databases forums.  There's likely to be a better understanding of DB4 in the correct forum.


Good Luck,
Kent
0
dmoss123Author Commented:
Kdo,

Sorry about that.  I  will list the solution we came up with and close this out.

SQL 2005 does not allow for exporting tables to DB4 files. However SQL 2000 does. At lease for now, were running a nightly process that copys the tables to SQL 2000 and then save them to DB4 files. Not perfect solution, but it is the cleanest work around we could come up within our timeframe.
----------------------------------------------------------------------------------------------------------------------------
References
http://msdn2.microsoft.com/en-us/library/aa337084.aspx

The SQL Server Import and Export Wizard in SQL Server 2005 does not support importing from, or exporting to, dBASE or other DBF files. You can use Microsoft Access or Microsoft Excel to import the data from DBF files into an Access database or Excel spreadsheets, and then use the SQL Server Import and Export Wizard.



0
dmoss123Author Commented:
Sorry for posting the question in the wrong location.
I included the solution we came up with if any of you are interested.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.