Topic > An idea to bring SQL Server Management Studio to...

We are not talking about implementing a database for mobile devices using SQL Server Compact, rather we are here to discuss any possibility of bringing SQL Management Studio to portable devices in all or in part. The day Apple's iOS and Google's Android transformed the existing world of portable devices, everyone is talking about bringing the giant computer applications and features to smartphones, tablets, PDAs, etc. Lo and behold, the idea of ​​bringing a gigantic-sized server with saber-tooth-like features to a tiny device sometimes seems impossible. However, controlling a large device like a 44-inch television using a small remote control is the reason for this imagination to use a mammoth like SQL Server Studio on a small mobile phone. Why is SQL Server Management Studio a mammoth? Yes, it's true for those organizations that use it extensively as a backbone. Sometimes SQL Server Management Studio (SSMS) consumes a lot of system resources even on servers with the latest configuration and often results in a bottleneck situation. That's why experts always recommend using the latest version of SQL Server, Windows Server and a new hardware setup. To minimize such possibilities or to have a lite version, users often resort to custom installation of SQL Server or try to choose between Compact and Express editions. What's the idea? The idea of ​​bringing the full version of SQL Server Management Studio to mobile might seem like a process of fitting a mammoth into a pocket-sized box. The mammoth can easily break its walls and harm the person carrying the box and releasing it. However, if we imagine handling an elephant with a hook and controlling a large television via a tiny remote control, then there are some possibilities... half of paper ......mobile and already consumed more than 50% of the mobile resources , it should be automatically moved to the server with a message: “This action is consuming more resources than expected; therefore, it is moved to the server. Make sure you are connected to SQL Server. "Conclusion It is not possible to transfer the complete configuration of SQL Server Management Studio to mobile devices; however, its small remote control form can be easily migrated to portable devices. Connected to the few databases of a SQL Server using Windows Azure or other clouds , this proposed mobile application allows users to initiate the command and decide automatically or with user input where to execute the command on the device itself or at the server end Both SQL Server and the mobile application should be automatically synchronized always or at scheduled intervals.