Use SQL Server's Backup to create a dump file. Then take that dump file to the client's machine. Create the device(s) and database with the exact same size parameters. Use Restore to restore the dump, using the Add File button to locate the dump file.
This is a brief description of how we do it. If you need a more detailed explaination, email me and I'll put one together.
HTH
>Hi All,
>
> I have developed an applcation in VFP using SQL Serve 6.5 as a backend. Now Application is ready to be Installed to Client site. I want to know the best/easiest way to take SQL Server DataBase to the Client Machine from my office.
>
>Bye
>Jayesh
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
