How do I Move a Microsoft SQL Server Book to new Server?
Open Microsoft SQL Server Management Studio
If you don't have Microsoft SQL Server Management Studio you can download and install it from here
Connect to the SQL Server instance with the current Microsoft SQL Server Book on it
Expand Databases
Select the Microsoft SQL Server Book / Database to move.
Ex: Demo Book
Right Click on the Book
Select Tasks->Back Up...
Select Copy-only backup
Click the Add button
Click the ... button to specify the file name for the backup
Select a Path
Enter a File name
Click Ok
Click the OK button
Click the OK button
If the backup is successful you will see the following message
Create EZ Arms Keeper login on new server with EZ Arms Keeper
Open EZ Arms Keeper
File->Open
Bound Book Type: Microsoft SQL Server
Server Name: Microsoft SQL Server Instance name the book is being moved to
Method: SQL Server Authentication
Login: Login that has permissions to create databases and add logins
Password: enter the password
Bound Book Name: TestBook
Click the OK button
Creating the TestBook on the server will also setup the EZArmsKeeper login on the server which will be important for restoring the backup
Connect to the SQL Server instance that the Book is being moved to
Expand Databases
Select the TestBook
Right Click on the TestBook
Select Delete
Select OK
Select Databases
Right Click on Databases
Select Restore Databases
Select Device
Click the ... button
Click the Add button
Select the file that was previously backed up
Click the OK button
Click the OK button
Click the Files page
Click the Relocate all files to folder Option
Click the OK button
If the database was successfully restored you will see the following message
Expand the Database that was just restored
Expand Security
Expand Users
Select EZArmsKeeper
Right Click on EZArmsKeeper and select Delete
Click OK
Select Users
Right Click on Users
Click New User...
Click the Login name ... button
Click the Browse button
Select the [EZArmsKeeper] Login
Click the OK button
Click the OK button
Copy the Login name and enter it as the User name
Enter dbo for the Default schema
Select the Membership Page
Select the following Database roles
db_accessadmin
db_backupoperator
db_datareader
db_datawriter
db_owner
db_securityadmin
Click the OK button
The Book has now been setup and should be able to be opened via EZ Arms Keeper
Open EZ Arms Keeper
Open the Bound Book via File->Open
Bound Book Type: Microsoft SQL Server
Server Name: Enter the Microsoft SQL Server Instance Name. If the SQL Server Browser Service is running and the Firewall is properly configured then you can select the dropdown and select <Browse for more...>. This should populate the list of available servers to select from.
Bound Book Name: Name of the Book that was moved. You can select the dropdown and select <Browse for more...>. This should populate the list of available bound books on the server to select from.
Click OK
If you are able to successfully open the book you will see the EZ Arms Keeper update the Acquistion Counts, etc.
