Traditional Culture Encyclopedia - Hotel franchise - Have used ChinaSoft Tai Hao Hotel Management System or be familiar with SQL 2005. Teach me how to import data from one database to another.

Have used ChinaSoft Tai Hao Hotel Management System or be familiar with SQL 2005. Teach me how to import data from one database to another.

1. Separate the hotel database.

2. Copy all data files of the hotel database (located in the folder \ program files \ Microsoft SQL Server \ MSSQL \ data by default) to a new folder (for example: d:\XLHOTEL).

3. Attach a database and select the hotel database data file (in the \ program files \ Microsoft SQL Server \ MSSQL \ data folder by default). The database is called HOTEL.

4. Attach a database and select a data file named XLHOTEL (such as d:\XLHOTEL) as the database.