>>>>I am trying the VFP SQL Server Upsizing wizard. The first thing that has to be specified is Data Source. If I check Connections, the wizard shows no available connections. How and where do you specify Connections?
>>>
>>>I think (not sure, becuase I never used it) these must be connections defined in VFP DB.
>>
>>I will look into the VFP help on how to specify connections in VFP DB. Thank you for your help.
>
>OPEN DATA BASE 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?
"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