If you have any questions or if you need help please call us before attempting to upsize your data. The instructions below are the general process but the details will not be exact as it will depend on your data paths, SQL or MSDE installation, among other variables unique to your network and computer.
You will need the following to be complete before starting the upsize which should be done from the main computer or server:
SQL or MSDE installed and running. (Install MSDE Instructions)
Masterpiece installed and updated.
Know the SA password that was created when SQL/MSDE was installed.
Know where the Local Masterpiece Data currently is, and move it to the server if not currently there and point Masterpiece to the Data.
Create a folder where the new Data will be created, it can be on any computer or server as long as the folder is shared out.
Create a folder called “SERVERVIEWS” under C:\MASTERPIECE on the main
computer.
Open Masterpiece.
Go to Tools > Data > Copy Local Data to SQL Server.
You will be prompted for your SQL Server Upsizing Password (Please call
us for this password).
Which will open the following window:
Fill out the following fields:
SQL Server Machine Name is the name of the computer you are on.
Admin User Name is “SA” or whatever you created during SQL Install.
Password is whatever password you created in the SQL install.
---------------------------------------------------------------------------
SQL Server Database is “MASTERPIECE”.
Server Database Location is the local database location. This normally defaults to: C:\Program Files\Microsoft SQL Server\MSSQL\DATA but can be anywhere as long it is a folder that will not be overwritten as it will store your SQL Data once it is created. Typically you want it on a server or drive that is backed up.
---------------------------------------------------------------------------
VFP Data Directory is your current data directory. Normally it defaults to: C:\masterpiece\data or it can be anywhere and on any computer, but needs to be on the main computer you are doing the upsize from during this process.
Local Data View Directory is the folder you created earlier: C:\MASTERPIECE\SERVERVIEWS\.
---------------------------------------------------------------------------
SQL Server User is “SA” or whatever you created during SQL Install.
Password is whatever password you created in the SQL install.
Click the GO button and then click the YES button. This should start the upsize.
You will receive the following message when it is complete. The time
required to upsize depends on the size of your data file.
Click OK once you receive the prompt that it is finished.
Click the Close button to close out of the Upsize window.
Check the SERVERVIEWS folder via Windows Explorer to make sure files were created in it and it is no longer empty.
Go to Masterpiece.
Click Tools > Change Directories.
Change your Data Directory to read C:\MASTERPIECE\SERVERVIEWS\
Click SQL Data button.
Click Make Default.
Click the Save button.
This should now log you out so you can log back in and you should be
connected to the SQL Data via the Views.
Which you can check by checking the Title bar in Masterpiece to see if
it says (SQL) like in the below example.
Close Masterpiece so you can copy the SERVERVIEWS and masterpiece.ini to each computer you have Masterpiece installed on, see the below instructions.
Verify the Masterpiece folder is shared out on the server before setting up the work stations.
Make sure Masterpiece is closed on all computers including the Server/Main Computer.
Copy the SERVERVIEWS folder and the masterpiece.ini file from the Server to each computer that has Masterpiece on it.
Launch Masterpiece on each computer, they should all have (SQL) on the Title bar of the Masterpiece program.
You should document your SQL/MSDE and Masterpiece information as it will be needed in the future for troubleshooting or if you need to change servers or main computers.
Here is an Example Documentation using the above example:
SQL Server: KIM-MPS
Database: MASTERPIECE
User Name: SA
Password: strongpw
Data is stored at: C:\MPSQLDATA
on the computer named KIM-MPS.
We recommend you put the SERVERVIEWS and masterpiece.ini in a zip file
and store in it in several places such as the C:\BACKUP folder on several
computers.