• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 488
  • Last Modified:

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.
0
dmoss123
Asked:
dmoss123
  • 2
2 Solutions
 
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
 
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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now