نسخ قاعدة البيانات الخلفية سيكوال سيرفر من خلال واجهة اكسس

[tiger wanted]

بفرضا يوجد قاعدة بيانات خلفية sql server واجهتها اكسس كيف يمكن خلال واجهة اكسس نسخة قاعدة البيانات الخلفية sql server 

[Eng.Qassim]

بصراحة لم اعمل السكوال سيرفر

لكني وجدت لك هذه المقالة عسى ان تنفعك..واعتقد هي واضحة لاتحتاج للترجمة

·  Open the Access database that is currently interfaced with the SQL Server database.

·  Click on the "External Data" tab on the ribbon at the top of the Access window.

·  Click on the "ODBC Database" option in the "Import & Link" section.

·  In the "Select Data Source" dialog box, select the data source that is connected to the SQL Server database and click "OK."

·  In the "Get External Data - ODBC Database" dialog box, select the "Link to the data source by creating a linked table" option and click "OK."

·  In the "Link Tables" dialog box, select the tables that you want to copy from the SQL Server database and click "OK."

·  Access will prompt you to specify a primary key for each table that you are linking to. Choose the appropriate field(s) to use as the primary key and click "OK."

·  Access will create linked ·  tables that are connected to the SQL Server database. You can now work with these tables in the Access database just like you would with any other Access tables.

·  If you want to create a copy of the SQL Server database, you can use Access's "Make Table" query feature to create local tables that contain the data from the linked tables. To do this, create a new query, add the linked tables to the query, and then select the "Make Table" option from the "Query Type" section of the ribbon. You can then specify a name for the new table and run the query to create the table.

 

 

[Moosak]

حسب علمي البسيط عن قواعد الـ SQL  أن ( برنامج إدارة قواعد بيانات SQL ) به أداة خاصة لعمل النسخ الإحتياطية للقاعدة ويتم التحكم بها من خلال البرنامج ..

ولكن وجدت هذه المقالة والتي بها فكرة بديلة عن التواصل مع برنامج إدارة قواعد الـ SQL ، وهو عمل نسخة احتياطية لملف الأكسس بعد أن يتم تحويل جداول الـ SQL إلى جداول محلية (نفس جداول الأكسس) ..

وهذا هو المقال 🙂 :

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

To make a backup or copy of a linked SQL database as a back-end to a Microsoft Access database, you can follow these general steps:

 

1. Open your Microsoft Access database that contains the linked SQL database.
2. Make sure that there are no users currently accessing the database, as you will need exclusive access to the database to make a backup copy.
3. Right-click on the linked table in the Navigation pane and select "Export" from the context menu.
4. In the "Export - Access Database" dialog box, select a location and filename for the new Access database that will contain the backup copy.
5. In the "Export - Access Database" dialog box, check the "Export data with formatting and layout" checkbox to make a copy of the table data, or leave it unchecked if you only want to copy the table structure.
6. Click the "OK" button to start the export process. Access will create a new database file with the same table structure and data as the linked SQL database.

Note that this process only creates a backup or copy of the table data in the linked SQL database, not the entire SQL database itself. If you need to create a backup of the entire SQL database, you will need to use SQL Server Management Studio or another SQL database management tool to create a backup of the database on the server where the SQL database is hosted.

 

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------