Discussion:
Moving to SQL Need Help
(too old to reply)
jmillerWV
2008-05-02 14:31:00 UTC
Permalink
Hello all,
I am getting ready to move my Access 2003 DB (forntend /backend setup) to
SQL Server 2000 in Small Business Server 2003. I was wondering if anyone
could give me a good place to start on using the Upsizing tools and learning
about SQL server? Best practices, condition of Access database, size of
tables, best way to migrate data, does the Access frontend need to be changed
to a project those kind of things. One more bit of info the Access db sets at
1.5gb just data, frontend not encluded. Thanks in advance for your assistance.
John W. Vinson
2008-05-02 18:39:50 UTC
Permalink
On Fri, 2 May 2008 07:31:00 -0700, jmillerWV
Post by jmillerWV
Hello all,
I am getting ready to move my Access 2003 DB (forntend /backend setup) to
SQL Server 2000 in Small Business Server 2003. I was wondering if anyone
could give me a good place to start on using the Upsizing tools and learning
about SQL server? Best practices, condition of Access database, size of
tables, best way to migrate data, does the Access frontend need to be changed
to a project those kind of things. One more bit of info the Access db sets at
1.5gb just data, frontend not encluded. Thanks in advance for your assistance.
Take a look at

http://www.granite.ab.ca/access/sqlserverwhy.htm

and links therein.
--
John W. Vinson [MVP]
jmillerWV
2008-05-02 19:57:01 UTC
Permalink
Thank you for the reply. I will be looking at the link below this weekend.
Post by John W. Vinson
On Fri, 2 May 2008 07:31:00 -0700, jmillerWV
Post by jmillerWV
Hello all,
I am getting ready to move my Access 2003 DB (forntend /backend setup) to
SQL Server 2000 in Small Business Server 2003. I was wondering if anyone
could give me a good place to start on using the Upsizing tools and learning
about SQL server? Best practices, condition of Access database, size of
tables, best way to migrate data, does the Access frontend need to be changed
to a project those kind of things. One more bit of info the Access db sets at
1.5gb just data, frontend not encluded. Thanks in advance for your assistance.
Take a look at
http://www.granite.ab.ca/access/sqlserverwhy.htm
and links therein.
--
John W. Vinson [MVP]
Loading...