Hi!

This question is more about SQL Server database administration that about the VFP.

SQL Server contains its own tools to create a source code (T-SQL script) to re-create the complete structure of the entire database, include all stored procedures, views, security definitions etc. You create such script, then during installing application on anotehr side, you run that script for SQL Server for new empty database to re-create its structure.

Beware that many applications might require predefined data for certain tables, such as lookups, initial environment data etc. In such case it is wise to have also a separate script to populate tables by initial data.

Another way to do this is clean up your database, make a backup of it and send backup file to another side. At another side you just restore database from the backup file.

All could be done very easy using usual tools for SQL Server - Enterprise Manager and Query Analizer.

HTH.

>Hi everybody,
>
>Maybe this sounds stupid, sorry...
>
>I develop a VFP application on a SQL server Back-end. In my VFP project, I created a database in which I created a connection on my SQL server, than I created my remote views using this connection...
>
>Now my question is : How do I distribute this application ? I mean, what do I have to do to make it work at my customer on his SQL server ? When I distribute a VFP database, it's easy to give my customer an empty copy of the database, but how to do it with SQL server ?
>
>Thanks for helping !