Situatie
Solutie
Pasi de urmat
Create a folder on your desktop named “New Database”
- Open iBase Designer
- First, we will create a new security file. File -> New Security File and name it: “New_Database” (the account for this new security file will be SYSADMIN/SYSADMIN. You can change this later on and add users/groups as you need)
- Now, we will create a new empty database. File -> New Database and name it “New_Database”, pointing it to your SQL Server.
Once the new database has been created, you may close out of iBase and open up SQL Server Management Studio. You should be able to view both “Original_Database” and “New_Database”. At this point, “Old_Database” has all the data, but is inaccessible, while “New_Database” has no data, but is accessible.
- You will need to create a backup of the “Original_Database” if you do not already have one created.
- Right-click on your database -> Tasks -> Backup and create a Full backup of the database. By default, this backup will be created in C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup, but it could be in a different location depending on your environment.
Now we will restore “Original_Database” onto “New_Database”. Right-click on your new database and select Tasks->Restore->Database
On the “General” tab, select the “Device” radio button and ensure that the Destination database is set to “New_Database”
On the “Files” tab, ensure that the path under “Restore As” points to the new database.
On the “Options” tab, ensure that the “Overwrite” option is checked.
Now click “Ok” and the “Original_Database” should restore into “New_Database”. After this has completed, open up iBase Designer and login to your newly created security file and then your “New_Database”. You can now verify that your data, entities and links, exists in the new database.
Leave A Comment?