| Author |
Topic |
|
Jair
Starting Member
4 Posts |
 Posted - 2005-10-24 : 19:16:24
|
| hey,I am creating a tool for a PDA,The Data I need to access, currently is in .dbf files(created in a clipper program, a while back)but the only dbase supported in visual studio isSQL CE, so, how do I convert?and What file formats can SQL Server CE read?If they (the PDA SQL) are happy with a flat file, or delimited file, I can change the export routine to generate the files in this format.cheers, Jair. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-24 : 19:57:25
|
| To convert a dbf file into a SQL Server table, you can use DTS. SQL Server CE is a relation database and not flat files like what you currently have.Tara |
 |
|
|
Jair
Starting Member
4 Posts |
Posted - 2005-10-24 : 20:11:21
|
| Um.., thanks.but what is DTS, and how do I use it?cause I am developing the tool in Visual Studio,I have both 2003/2005, cause neither seem to do what I want.Jair |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-10-25 : 09:40:33
|
| "but what is DTS, and how do I use it?"...how about search here/google for the term?..but in short it's Data Transformation Service(s)...and sub-component of SQL Server.when you say you have 2003/2005...of what? VS or SQL Server/SQL CE?i suspect you need an ODBC driver to be installed to reference the db properly. |
|
|
|
Jair
Starting Member
4 Posts |
Posted - 2005-10-25 : 18:52:06
|
| "sub-component of SQL Server" that sounds promising,but is it compatible with the .net compact Framework?because the ODBC driver is not! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-25 : 18:54:01
|
| DTS can be used to convert your dbfs to SQL Server. They have nothing to do with the .NET framework. Once converted, everything will be inside SQL Server.Tara |
|
|
|
Jair
Starting Member
4 Posts |
Posted - 2005-10-25 : 18:58:03
|
| thanks, but can it export them back out as .dbf files?because the source for the tool, is being updated daily. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-25 : 19:01:13
|
| I would think so, but I doubt you'd want to do that. That would mean you'd be converting to SQL Server CE every single day, pushing that to the PDA, then back into the dbfs. Now that would be a long process. You need to convert over to CE completely and get rid of the dbfs.Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-25 : 19:02:00
|
| Do you even have SQL Server installed? If so, then you can try out DTS via Enterprise Manager. If not, you'll need to at least purchase the developer edition (49 bucks) or try it out via the Eval copy.Tara |
|
|
|
|
SQL Database in Windows CE