Hi, i have a DB in Access and i want to know if is possible convert it
to SQL and WinForm in .Net.
Thanks
Sure. You acquire the tools for developing those and you re-write everything
: )
Seriously, there are tools for upsizing your tables to SQL Server, but as with
all "wizard-type" tools they make assumptions that in some cases are incorrect
or at least undesirable. I prefer to use the SQL Server tools to build
everything myself. After all, you need to be familair with those tools AFTER
the conversion so why not become familar with them at the beginning of the
process?
A middle ground is to use DTS or SSIS to import the Access tables into SQL
Server. I generally find that "pulls" work better than "pushes" and with these
tools you have more control over the DataTypes created in the tables.
Admittedly those will not duplicate things like keys, default values, etc..
If there are tools that attempt to convert the interface portion of your app to
..net structures I have not heard of them and I have to believe that they would
only do a very rudimentary job of it leaving you a lot of work still to do
afterwards.
