|
|
|
Question: I plan to purchase your products, but before I make the purchase, I like to know your software upgrade policy.
|
|
For minor software upgrade (e.g. from 3.0 to 3.1), Best SoftTool offers free software upgrade for all licensed users. User can download the zipped software patches from our web site. Then unzip the patches to overwrite the files in installed folder. If you are not sure the process, you can backup all files before overwriting. For major software upgrade (e.g. from 2.0 to 3.0), the user need to purchase the upgraded software at full price.
|
|
|
| Question: When I use SQLDBCompare to Synchronize two SQL objects, I got following error message “Except caught. Reason=QueryInterface for InterfaceDTS.CustomTask failed”. Is anything wrong with the software?
|
| Answer: SQLDBCompare uses the DTS objects that come with Microsoft to do the SQL object synchronization. However, the initial version of Microsoft SQL Server 2000 contained a bug and it has been fixed in SQL Server 2000 Service Pack 2 and later service packs. If you download the latest service pack and install it on your server will clear this problem. For more information, please visit: http://www.sqldts.com/default.aspx?286. You can download SQL Server Service Pack 4 free from Microsoft web site. |
|
| Question: What happens when someone ALTER SQL Server database items outside SQLSourceSafe (for example, using Enterprise Manager)?
|
| Answer: If you want to use an external SQL editor, you should first check out the database item from SQLSourceSafe before editing it. You should also check it in after making changes to the database. Please note that SQLSourceSafe checks in the most current version of the database item. Before checking in your changes, you shall use the SQLSourceSafe to compare the change and ensure all changes are in SQL Server. It is important to check out the database item first to prevent others from modifying it while you are working on it.
|
| Question: What happens when I do a Get Latest operation to a table object? Are the records in the table got lost?
|
| Answer: When a Get Latest operation is performed on a table item, if there is a change in the table’s structure, a notification message box will prompt you dropping the table. If you click on Yes at the message box, the table in SQL Server will be dropped and all the data in the table are lost. A new table is created using the script in the SourceSafe. If you choose No at the message box, the operation is cancelled and the current table remains unchanged. To prevent lost data, you can do a Diff comparison for scripts in SourceSafe and in SQL Server. Then based on the difference, you can modify the table by using Enterprise Manager until the scripts are the same.
|
| Question: What I should do if I want to check out a table for modification but I do not want the current table get dropped?
|
| Answer: When a Checkout operation is performed, a message box pops up with checkbox "Don’t update the database item on SQL Server". If you check the checkbox and click on the OK button, the database item is marked as checked out but the corresponding database item on SQL Server remains intact. This option is similar to "Don’t get local copy" in Visual SourceSafe.
|
| Question: How do I deploy the database items in SourceSafe to a SQL Server?
|
| Answer: Create a connection using the SQLSourceSafe connection wizard. In the connection wizard, specifies the SQLSourceSafe connection name and Visual SourceSafe settings in the SourceSafe page, and the SQL Server settings in the next page. Click on Finish button, you will be taken to the SQLSourceSafe main window. If the SQL Server database does not exist at this moment, a message box will pop up asking “The database xxx does not exist. Do you want to create database xxx on SQL Server yyy?.” Click on the Yes button will create xxx database on the yyy server. On the SQLSourceSafe main window you will see all database items in SourceSafe at left pane of the window. Select SourceSafe\Get Latest Version from the main menu, it will create database items on the SQL Server using the database items in SourceSafe.
|
| Question: Why I need to run the Get Latest Version operation several times if I want to create a SQL Server database and all items from SourceSafe?
|
Answer: Some database items maintain dependency on other database items. So the depended database items shall be created before the dependent database items get created. However, SQLSourceSafe creates database items based on their listed order in the SourceSafe. Therefore, creating some database items will have some problems if their depending database items have not created yet.
To get around this problem, you can issue the Get Latest Version operation several times to ensure all depending objects get created. It is recommended to clear the Message Pane before each Get Latest Version operation. When a Get Latest Version operation does not show any red color text message in the Message Panel, it means the create SQL Server database succeed.
|
| Question: Trying to create a new connection but keep getting the following message "The sourcesafe Database ini file does not match the username and password you entered! Reason =COM object with CLSID {783CD4E4-9DF4-11CF-B8EE-00608CC9A71F} is either not valid or not registered.."
|
Answer: The problem you encountered is the COM object for the Visual SourceSafe is not registered. The problem might come from you installed some version control software and the software did their COM registration that overwrote the default the SourceSafe COM registration. After you uninstall the version control software, the registered COM object got removed as well.
To get around this problem, you can register the COM object manually. You can open a console window and change the current path to the folder the SourceSafe is installed and find the file “SSAPI.DLL”. Then type the following command: regsvr32 ssapi.dll. After pressing the Enter key, you will see a confirmation window. You should be able to connect to SourceSafe at this time.
|
| Other Question:
|
| If you have other questions that are not listed here, please send your question by email to info@bestsofttool.com or support@bestsofttool.com.
|
Frequently Asked Questions
