Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravl13
Starting Member
38 Posts |
 Posted - 2011-08-19 : 15:01:53
|
| Greetings,NOTE: I don't know a whole lot about databases, and so my terminology may be a bit off.I've been given a terrible and old database system called JSI Paradigm, and am supposed to retrieve as much information as possible from the database in it. Problem is, the people who gave the system to me have no idea how it works, and I get connectivity errors whenever I try to use the Paradigm Client system. I have located the actual database file (it has a .db extension), but it was not created with Microsoft Paradox, which a google search on ".db" would lead you to believe; It was created by a program called Paradigm. So, my question is: is there a way for me to take that .db file, and import the tables in it into SQL Server 2008? I don't care if any table relationships and whatnot are maintained; the main thing I need to get is people's names and contact information. I can't involve the actual Paradigm in the importing procedure, because I have no clue how it works, and can't get it to function.Thanks for your time, -ravl13 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ravl13
Starting Member
38 Posts |
Posted - 2011-08-29 : 15:20:29
|
| I don't have a Paradigm driver, but I think the underlying actual server is SQL Anywhere. I can't find any drivers for that online, surprisingly. Perhaps I'm not searching correctly; If someone could point me to a SQL Anywhere driver, it would be much appreciated. |
 |
|
|
|
|
|
|
|
Able to import a plain .db file into SQL Server?