SANOGO Posted May 18, 2019 Share Posted May 18, 2019 bonjour j'aimerais avoir un script pour faire le mirroring de ma base de données du disque principal vers une autre disque.La disponibilités des bases de donnée (Mirroring/principal ) sur les deux serveurs.Merci! Link to comment Share on other sites More sharing options...
water Posted May 18, 2019 Share Posted May 18, 2019 Welcome to AutoIt and the forum! This is an English speaking forum. So please either write in English, use Google translate or post on the French forum Back to your question: What have you tried so far and doesn't work? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
SANOGO Posted May 18, 2019 Author Share Posted May 18, 2019 hello I would like to have a script to mirror my database from the main disk to another disk. The availability of databases on both servers. Thank you! Link to comment Share on other sites More sharing options...
SANOGO Posted May 18, 2019 Author Share Posted May 18, 2019 hello I would like to have a script to mirror my database from the main disk to another disk. The availability of databases on both servers. Thank you! Link to comment Share on other sites More sharing options...
Developers Jos Posted May 18, 2019 Developers Share Posted May 18, 2019 So you seriously think you can create 3 time the same topic in different threads and assume you get faster help? Please don't and stick to normal forum etiquettes! Having said that: What is the relation to AutoIt3 with the posted topic? Jos SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
SANOGO Posted May 18, 2019 Author Share Posted May 18, 2019 I wrote in French for the first and for the second post I did not pay attention! Link to comment Share on other sites More sharing options...
Developers Jos Posted May 18, 2019 Developers Share Posted May 18, 2019 Well you created 3 threads instead of simply using the one. .... and please also stop changing the font of our post. Just simply use the standard font unless there is something to emphasize. So, you forgot to tell me what these threads have to do with AutoIt3! Thanks/Jos SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
jchd Posted May 18, 2019 Share Posted May 18, 2019 Quote script to mirror my database from the main disk to another disk It depends on the DB engine you use, which you say nothing about. 37 minutes ago, SANOGO said: The availability of databases on both servers. This sentence has no semantic. Do you mean you want both DBs always synchronized in real time, mirrored regularly, whatelse? This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
SANOGO Posted May 18, 2019 Author Share Posted May 18, 2019 (edited) 1 hour ago, jchd said: Cela dépend du moteur de base de données que vous utilisez et pour lequel vous ne dites rien. Cette phrase n'a pas de sémantique. Voulez-vous dire que vous voulez que les deux bases de données soient toujours synchronisées en temps réel, régulièrement mises en miroir, et quoi d'autre? yes, that's it to put the two databases are always synchronized in real time, regularly mirrored Edited May 18, 2019 by Jos removed formatting of the text Link to comment Share on other sites More sharing options...
Developers Jos Posted May 18, 2019 Developers Share Posted May 18, 2019 Again, what is the relation to AutoIt3? Do you know which commands to use to copy the database, but want Autoit3 to do those commands for you or do you want to know how to copy a database? So start providing some real information! SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
SANOGO Posted May 18, 2019 Author Share Posted May 18, 2019 I want to make a button, a click on the button and the copy is executed from the main database to the secondary database. Link to comment Share on other sites More sharing options...
jchd Posted May 18, 2019 Share Posted May 18, 2019 Once again (and for all): which DB engine are you using? 2 hours ago, SANOGO said: two databases are always synchronized in real time, regularly mirrored Both things are incompatible. Also note that keeping live (being read from/written to) two or more DBs in sync and in real time is either very costly and/or very slow and/or very unreliable or plain impossible in practice. Duplicating a DB at more or less regular intervals is easy and easily automatable, provided you can tell us which engine you use! This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
SANOGO Posted May 18, 2019 Author Share Posted May 18, 2019 base de données SQL Server Link to comment Share on other sites More sharing options...
jchd Posted May 18, 2019 Share Posted May 18, 2019 Pas la peine de hurler avec un police de cette taille ! https://docs.microsoft.com/fr-fr/sql/relational-databases/databases/use-the-copy-database-wizard?view=sql-server-2017 This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt) Link to comment Share on other sites More sharing options...
Developers Jos Posted May 18, 2019 Developers Share Posted May 18, 2019 (edited) 4 minutes ago, SANOGO said: base de données SQL Server Seriously? I like to be taken serious so we are done with your questions here, and don't start this in a new thread again. *cick* Edited May 18, 2019 by Jos FrancescoDiMuro and Exit 2 SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
Recommended Posts