Others: How to change or rename database name

From AutoCount Resource Center

Question: How to change or rename database name?

Version: 1.8 / 1.9 / 2.0


Answer (1):

1) Make sure all users have logout AutoCount. Search and open SQL Management Studio from window search.


2) Go to Databases, then select the database you want to rename.


3) Right click on the database that the user wants to rename, then click on “Rename”.


4) Key in the new database name, then press Enter. The database name is changed.


5) You need to reset configuration as the database name is changed.

Please refer to:

https://wiki.autocountsoft.com/wiki/Others:_How_to_reset_account_book_list_for_login_screen


Or use the Edit Account Book function to switch the new database name.

https://wiki.autocountsoft.com/wiki/Others:_Manage_Account_Book_-_What_is_%27Edit_Account_Book%27_for%3F


Answer (2):

In SQL Management Studio, execute the following query.
USE master;
GO
ALTER DATABASE [Old Database Name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE [Old Database Name] MODIFY NAME = [New Database Name] ;
GO
ALTER DATABASE [New Database Name] SET MULTI_USER
GO




Refresh, and now the database name is changed.


By: Cit Ta 220809, Lay Swan 220825, P220829


Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations