need the source code for a software project like : http://www.sobolsoft.com/m
do not expect hare a complete soltution, any good hint eg.
how to create the mssql table based on the paradox table will be helpful
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
a decade ago i had this too
it's easier to allways give the mssexpress edition and just give a different exe
or use a different license key
you would only have 1 install
and moreover only 1 sql language for your app
and only 1 pass to test (instead of testing on 2 types of databases)
you have a design maintenance of at least 3 people like this
with only the mssql you reduce this 1 person
this is just overhead, and not worth the time and money
believe i've done this for 2 years and all the work of those 2 years could have been done in 6 months
yes,
it is from experience that i tell you this
we also had this plan to keep a paradox/dbase version and mssql version
it turned out there was a lot less maintenance on the mssql
(no rebuild index, no deletion by users of files, no paradox locking problems)
we could even give the maintenance stuff to others,
like backups to the network admins
and mirrored drives etc
and when you have a client which allready has a mssql server (not the express)
there is no work on your part for the database maintenance at all
just asking if they backup the database for you
you also get a lot more processing power and a lot more functionality in the database
you will need a conversion program (separate from your app)
i have created this in the past
if you are interested in this, then i will upload it
(it was for dbase to mssql)
the thing you need to do is create a script to create the database, tables, functions, procedures, triggers, etc on the mssql database
if the scripts are there, i'll upoad that too
again, if you are interested
Hi Geert,
I'm very interessted in your app and some of your sql scripts , would like to used that stuff for my application.
I tried : http://www.sobolsoft.com/m
Best
Bernhard
Business Accounts
Answer for Membership
by: Geert_GruwezPosted on 2009-10-30 at 04:36:10ID: 25701885
on the mssql cd there is a tool to do this
it requires some configuration.
it's known as DTS: Data Transformation Services
You specify a odbc source (your paradox) and a destination (a mssql)
and this process should do the rest
why reinvent the wheel ?