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.

Rename db.png


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

Rename db1.png


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

Rename db2.png


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

Rename db3.png


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


Rename db4.png


Rename db5.png


Refresh, and now the database name is changed.

Rename db6.png


By: Cit Ta 220809, Lay Swan 220825, P220829


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations