[AccessD] A2k to sql

Hi

I have an application written using A2k and have now moved to SQL 2000.
Can anyone give me advice in how to distribute an app that uses SQL as
the BE.

Is it as simple as generating a SQL script from my SQL db and then
running this script on the client server via query analyzer? Or do I
copy the mdf files? Or is there some third pary stuff that installs?

Any help would be appreciated

Richard