>>>>>
>>>>>OPEN DATABASE MyData
>>>>>
>>>>>CREATE CONNECTION [ConnectionName | ?] [DATASOURCE cDataSourceName]
>>>>> [USERID cUserID] [PASSWORD cPassWord] [DATABASE cDatabaseName]
>>>>>| CONNSTRING cConnectionString]
>>>>>
>>>>
>>>>Thank you for your code.
>>>>
>>>>I thought that the upsize wizard would create a SQL Server database of the same name as VFP database. But from your code it means that I have to create a DB in SQL Server before I can upsize the VFP DB, right?
>>>
>>>No, you could use Connection string and in it not put DataBase=....
>>
>>I wonder what would happen if you don't put Database in the Connection string. To which database would the upsize wizard would connect?
>
>It will create a new database on server with name of your VFP DB.
Interesting. I will experiment with this. I just hope that I am not going to damage my SQL Server with running upsize wizard with various parameters/no parameters. But, so far, from what you are telling me, I like the way the wizard should work: put tables in an existing database or create database, depending on the parameters.
Thank you very much for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham