Knowledge Base

Category » SQL Issues

There were 14 articles found in this category:

1. How to restore my LocalDB into SQL Server?
   Since version 5, SourceAnywhere supports Microsoft SQL Server 2012 Express LocalDB. You can choose either LocalDB or your own SQL Server to store your SourceAnywhere database when installing the server. With LocalDB, you will be able to evaluate SourceAnywhere smoothly without installing SQL Se ...
2. How to backup and restore SourceAnywhere database in SQL Server Management Studio?
   1. Backup SourceAnywhere database through SQL Server Management Studio. For this example, we will backup the database named "backmeup" to our "C:\backup" folder. Please be aware that the default database name of SourceAnywhere is "SourceAnywhere". Once connected to your database server, you ...
3. How to create an auto backup plan in SQL Server?
   This article will walk you through how to create an auto backup plan through SQL Server Agent. For this example, we will create a full backup every week, a differential backup every day, and a log every half an hour. Now let's create three script files for the code. The files can be named "SAWFu ...
4. How to Source Control SQL Server Stored Procedure using SourceAnywhere in VS 2012/2015?
   This article indicates how to version control your SQL Server Stored Procedure using SourceAnywhere in Visual Studio 2012.  Please follow the steps below:  1.    Lauch VS 2012 and open an existing SQL Server Database project or create a new one. 2.    Then your database is imported in Solut ...
5. How to move one repository from one database to another existing database of SourceAnywhere?
   With SourceAnywhere, you can configure different databases on different servers. Sometimes, you may want to move one repository from one database to another database. This can be achieved using the feature of Multiple SQL Server Database support added in SourceAnywhere 4.x or later. For more in ...
6. How to connect to SQL Server or SQL Serve Express?
   Dynamsoft SourceAnywhere Standalone will create a database named with "SourceAnywhere" on SQL Server installed on the local machine or a different machine on the network. You can choose to have Windows Authentication or SQL Server Authentication to connect to the SQL Server. If you are not sure ...
7. How to source control stored procedures?
   To bind a database project to version control, please follow the steps below: 1. In Visual Studio 2005/2008, click menu File->New->Project. Choose "Other Project Types"->"Database"->"Database Project" and type in your server connection info. 2. Use Server Explorer to connect to your ...
8. Error Message: Checking out FILENAME: Invalid column name 'bExclusiveCheckOut'
   Symptom: When you check out a file in SourceAnywhere Standalone Client Explorer, you may receive the following error in the output window: Checking out FILENAME: Invalid column name 'bExclusiveCheckOut'. Cause: This issue is caused by that the database column names are case-sensitive in your SQ ...
9. Where is the source code file data of SourceAnywhere Standalone stored in SQL Server?
   The file content of the SourceAnywhere Standalone repositories is stored in the dbo.tblFileInfo and dbo.tblExtraFileInfo tables in 'SourceAnywhere' database in SQL Server.
10. Do I have to install SourceAnywhere Server on the SQL Server machine?
    No. SourceAnywhere Server can be installed on a different machine to the one hosting SQL Server. However, for better performance, we recommend you to install the SourceAnywhere Server on the SQL Server machine that hosts the 'SourceAnywhere' database.
11. Is it easy to backup the system?
    Yes, it is easy. All the data are stored in Microsoft SQL Server. To back up the system, you only need to backup the SQL Server database.
12. How to backup the data?
    You need to use a SQL Server tool to backup the data. SourceAnywhere Standalone does not have backup tool, since we feel the SQL Server backup tool is already powerful and easy to use. For how to backup database in SQL 2000, you may refer to: http://www.microsoft.com/technet/prodtechnol/sql/200 ...
13. How date-time is stored in "SourceAnywhere" database in SQL Server?
    SourceAnywhere Standalone uses Windows FILETIME Structure. For more information about FILETIME, please refer to: http://msdn2.microsoft.com/en-us/library/ms724284.aspx
14. Which version of SQL Server does SourceAnywhere support?
    SourceAnywhere supports Microsoft SQL Server 2000, SQL Server 2005, SQL Server 2008 and above, MSDE and SQL Server Express. Moreover, since version 5 SourceAnywhere supports built-in database. This option is available to be chosen when installing the server.