Create sql server tables and migrate?

[Hfnet]

How could I create a vfp system using SQL Server, and package it so that I could install it on my work system?

I have an sql server at home where I do my programming, and I am going to embark on a VFP project, but want to eventually install it on my Work domain, so on first install to a pc I would want to automatically create the tables etc...

Thanks

 

[Mike Lewis]

Hfnet,

This is easy. Essentially, you can get Enterprise Manager to create the scripts you need to automate the setup.

Navigate to the table of interest in Enterprise Manager. Right-click on it, select All Tasks / Generate SQL Script. Click on Show All, then Select All Objects, then Preview.

You will see all the scripts you need to create the table, indexes, constraints, and so forth. Take these scripts to work, and run them either in the Query Analyser or from VFP.

These steps are for SQL Server 2000. They might be slightly different in other versions.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[Hfnet]

That's great, thanks.

I had a look at your site, and made one observation in which I can throw some info your way. You use shell commands:

I use an Access mde/sql server system at my workplace currently, and use shell execute and print api functions.

A few weeks ago, they stopped working, with no errors or anything.

Turns out it was Kaspersky Antivirus blocking the shell and api commands. There is a secret setting to block without notification!

Just in case anyone ever asks you why theire function stops!!

 

[Mike Lewis]

Hfnet,

Interesting. I'll keep it in mind. Thanks.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)