Jin wrote:
Hello, every one:
If I want to move tables from Access 2003 to Back-end SQL Server,
should I use Dababase splitter or upsizing wizard? or just import
tables?
Thanks for your help.
I import the tables. Then I use the database diagram facility to modify
each table, index and relationship appropriately.
I rewrite every saved query as a view, stored procedure, udf or
whatever. In some cases I may transfer SQL strings used in code in a
similar way.
Views can be indexed but they are, IMO, more limited than SELECT stored
procedures. I tend to use SELECT stored procedures to the exclusion of
views.
I do not want to pay in money and time for an SQL database and end up
with a JET/Access database living in an SQL Server.
After I have a real SQL-Database I can do whatever I want with it, and
use Access as a front-end or NOT. Lately it's been NOT.