I am planning to convert an existing Access database which has a back
end
(data tables and relationships only) on a server and a copy of the front
end
(form, queries, reports) on each of about a dozen workstations.
I intend to convert the back end to SqlServer and wish to use the
upsizing
wizard. I am acquiring SSW Upsizing Pro! 2000 which seems to be
recommended in other discussions.
I have some questions in mind:
1 how will I change the SqlServer tables e.g. add/delete a field
to/from a
table, or add/delete a table?
2 how are relationships handled in SqlServer? (I need cascading
deletes)
Do I need to obtain any other tools, such as SqlServer itself to be able
to do
things like this?
At this stage I want the simplest possible conversion. The database
works
perfectly well at present but intermittent network problems mean that it
would be better to have the back end as SqlServer. I can delay
implementing
other benefits until a later stage.
Advice as to which good books to read would be useful. I have developed
a
number of Access databases and am competent in writing VB (and other
languages) but have minimal knowledge of SqlServer.
Ron Devenish
*** Sent via Developersdex http://www.developersdex.com ***