Migrate SQLite to MySQL

I’m developing a huge app made with Xamarin Forms in my company. A problem was to create all tables in the device with SQLite to the main database MySql.

SQLLite-To-MySql-1

I found a way to create all tables quickly with a tool called SQLite to MySQL.

SQLite-to-MySQL is a powerful and reliable tool to convert SQLite databases to MySQL, MariaDB or Percona format. The program has high performance due to direct connection to source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

SQLLite-To-MySql-2

SQLLite-To-MySql-3

Features

  • All versions of Linux/Unix and Windows MySQL servers are supported
  • Option to customize resulting table structure
  • Convert indexes and relationships between tables
  • Stores conversion settings into profile
  • Option to filter data using SELECT-queries
  • Option to merge SQLite data into an existing MySQL database
  • Option to synchronize MySQL database with SQLite data
  • Support for multibyte character sets
  • Option to export SQLite database into MySQL script file
  • Verified compatibility with MariaDB and Percona
  • Option to customize MySQL storage engine and MySQL charset
  • Special approach for Virtual Server users
  • Command line support
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • 1-year subscription for updates
    SQLLite-To-MySql-7

Click here to download and try it.

Microsoft's Home Hub ambitions aim to crush Google Home and Amazon Echo

homehubui-concept

In what might be the most exciting part of this whole project, Microsoft is working on bringing the connected "smart home" to Windows 10 with Home Hub. The goal is to make Windows 10 the central hub for all your smart home devices, including lights, doors, locks and more. With Cortana integration allowing you to use your voice to toggle and control the smart devices in your home, the picture for Home Hub becomes complete: it brings Windows 10 to the center of your entire home.

Microsoft is building a dedicated "Connected Home" app that will make adding smart devices to your home easy; with an overview of all the smart devices in your home and options to turn them on and off, configure them, and more. You'll also be able to group devices to individual rooms; for example, you could have Hue lights 1, 2 and 3 grouped under the Bedroom tag and tell the Home Hub to "turn off the bedroom lights". This app will work much like most other smart home apps, except this one will have deep integration with Windows 10.

Home Hub Timeline

Home Hub is a massive project for Microsoft, with a lot of it planned across for Redstone 2, 3 and 4. It's unclear when we should expect to see the whole set of Home Hub features show up for consumers. Some sources have suggested the first batch of major Home Hub bits will arrive with Redstone 3, with smaller features such as Family Desktop showing up sooner with the Creators Update.

Although Microsoft has internal projections for this stuff, that doesn't make it immune from delays or even cancellations. That's a frequent occurrence at any tech company of Microsoft's size — internal projects don't always work out, and sometimes they rise and fall entirely without public knowledge of the plans.

Most of the sources we've spoken to have all said a lot of the Home Hub stuff had been delayed for more important changes and improvements that need to be made to Windows 10, which is understandable. No single source has explicitly said that the big Home Hub stuff has been canceled, but we have heard that it might be a while before any of the interesting stuff begins to show up in public.

Read more on WindowsCentral.

Microsoft is working on a new design language for Windows 10 codenamed Project NEON

comparison_metro_vs_mdl2_a

Microsoft has made several adjustments to its design language over the last few years, starting with Windows 8 and evolving into what we now know as "Microsoft Design Language 2" or MDL2 in Windows 10. With MDL2 being the current design language used throughout Windows 10, Microsoft has plans to begin using a much more streamlined design language with Redstone 3, codenamed Project NEON.

A Metro 2.0?

Cassim Ketfi at Numerama.com confirms our information and has heard Project NEON called "basically Metro 2". That designation refers to the first Metro design language (née Modern) that harkens to Windows Media Center up through Windows Phone 7 and Windows 8.

Metro was the defining look of the Windows Phone OS with strict principles and guidelines. It also kicked off the design movement of flat, chrome-less design focused on simplicity that even iOS and Android now mimic.

Per our sources, Project NEON has been in the works for over a year internally at Microsoft. It builds upon the design language introduced with Windows 10, with its simple and clean interfaces, but adds some much-needed flair to the UI that the current design language just lacks.

Details are still scarce, but we hear some of the new designs in the plans include adding more animations and transitions, with the overall goal of making the UI very fluid and "beautiful" compared to the current, almost static UI that is MDL2. One source familiar with Microsoft's plans described NEON as "Very fluid, lots of motion and nice transitions."

Other things we've heard include app-elements being able to "escape" the borders of a window making for a much more unique experience.

Some more information about NEON reveals that it serves as a bridge between holographic and augmented reality (AR) and the desktop environment. It's a "UI that transports across devices" with a UX that maps to the physical world. It uses textures, 3D models, lighting and more.

groovedesign

Timeline

Internal plans appear to suggest that the bulk of this new design language will start showing up with Redstone 3 in the early Fall of 2017, but Insiders will likely start seeing these new changes a lot sooner, as Insiders are supposed to start receiving RS3 builds in April-May. There is also a reasonable chance we may see some NEON bits begin to appear in Redstone 2 in early 2017.

Microsoft will continue working on Project NEON throughout Redstone 3's development cycle and leading into Redstone 4 in 2018, where 3rd-party developers will also be able to take advantage of the new design language.

Satya Nadella: Microsoft building the 'ultimate mobile device'

Sadella-Melbourne

Microsoft CEO Satya Nadella has again reaffirmed the company's commitment to developing smartphones. Unfazed by its market share dropping beneath 1 percent, Nadella said Microsoft is planning a revolutionary "ultimate mobile device."

Nadella made the comments during an interview with the Australian Financial Review. He visited Sydney last week to address a local developers conference about Microsoft's cognitive computing systems and Azure cloud services.

Nadella outlined his plans for Microsoft's future involvement with smartphones. He suggested the company has stopped trying to rival the established leaders in the field. Instead, Microsoft is working on something for the future that it thinks will give it the upper-hand in the long term.

lumia1

Nadella hinted at an "ultimate mobile device" that could give Microsoft a credible presence in the industry. The company seems keen to develop a product with unique capabilities that aren't replicated by its rivals. A key feature that already fits this description is the company's Continuum tech, Windows 10 Mobile's ability to transform itself into a desktop PC at a moment's notice.

"We will continue to be in the phone market not as defined by today's market leaders, but by what it is that we can uniquely do in what is the most ultimate mobile device," Nadella said. "Therefore [with Nokia assets], we stopped doing things that were me-too and started doing things, even if they are today very sub-scale, to be very focused on a specific set of customers who need a specific set of capabilities that are differentiated and that we can do a good job of."

Xamarin Forms and Google Mobile Ads for iOS: update

In my previous post I explaind how to add on your application advertising. In those days Xamarin has removed from the Component Store the component called Google Mobile Ads for iOS.

Now you have to install another component called Firebase AdMob for iOS.

Firebase_admob_ios

After installed this component you can see in your Output window a similar info without see an advert in your app:

2016-11-18 11:28:14.853 WordBankEasy.iOS[11103:2250070] <Google> You must set the rootViewController property of <GADBannerView: 0x1034702c0; frame = (-10 0; 320 50); clipsToBounds = YES; layer = <CALayer: 0x174e39d40>> before loading a request.

To fix this issue you have to find before the right UIViewController. For that you can use the following code:

    UIViewController viewController = null;
    foreach (UIWindow rootView in UIApplication.SharedApplication.Windows) {
        if (rootView != null) {
            viewController = rootView.RootViewController;
        }
    }

    adView = new BannerView(size: AdSizeCons.Banner,
                            origin: new CGPoint(-10, 0))
    {
        AdUnitID = AdmobID,
        RootViewController = viewController
    };

Happy coding!

Bill Gates awarded a Presidential Medal of Freedom

Bill-Gates-Apple-FBI-620x383

Outgoing President Barack Obama today names Bill Gates as one of the 21 recipients of the Presidential Medal of Freedom.

The Presidential Medal of Freedom is the Nation’s highest civilian honor, presented to individuals who have made especially meritorious contributions to the security or national interests of the United States, to world peace, or to cultural or other significant public or private endeavors.

The medal has previously been awarded to such luminaries as Mother Teresa and Stephen Hawking and was awarded for Bill Gates’s charitable work after he exited Microsoft in 2008. The Bill & Melinda Gates Foundation aims to help all people lead healthy, productive lives. In developing countries, the foundation focuses on improving people’s health and giving them the chance to lift themselves out of hunger and extreme poverty. In the United States, the mission is to ensure that all people—especially those with the fewest resources—have access to the opportunities they need to succeed in school and life. The Gates Foundation has provided more than $36 billion in grants since its inception.

President Obama said, “The Presidential Medal of Freedom is not just our nation’s highest civilian honor – it’s a tribute to the idea that all of us, no matter where we come from, have the opportunity to change this country for the better.  From scientists, philanthropists, and public servants to activists, athletes, and artists, these 21 individuals have helped push America forward, inspiring millions of people around the world along the way.”

One of the founders of Microsoft in 1975, Gates stepped down as chief executive officer of Microsoft in January 2000. He remained as chairman and chief software architect until 2006, when he transitioning from full-time work at Microsoft to part-time work, and full-time work at the Bill & Melinda Gates Foundation.  His last full-time day at Microsoft was June 27, 2008 and he stepped down as chairman of Microsoft in February 2014, taking on a new post as technology adviser to support newly appointed CEO Satya Nadella.

The awards will be presented at the White House on November 22th and livestreamed at www.whitehouse.gov/live. See the full list of recipients at Whitehouse.gov here.

Microsoft delivers test builds of Visual Studio for Mac, Visual Studio 2017 for Windows

Visual Studio for Mac is not a port of Visual Studio for Windows; it's a rebranded version of Xamarin Studio integrated development environment (IDE) that will work on the Mac. (Microsoft bought mobile-tool vendor Xamarin in February 2016.) Visual Studio for Mac is available as of today as a preview for download.

Visual-Studio-Mac

Visual Studio 2017 is the official name of the product Microsoft has been calling "Visual Studio Next" and/or codename "VS '15'." As of today, a near-final Release Candidate version of that product is available to testers. The RC includes a few brand-new features, but is mostly complete at this point. Officials told me this week that the final/general availability version of Visual Studio 2017 would be out in early 2017.

Microsoft made these announcements at its Connect() 2016 developer event in New York City on November 16.

At that event, Microsoft also announced it is joining The Linux Foundation as a Platinum member, and that Google is joining the .NET Foundation's Technical Steering Committee. The .NET Foundation is the vehicle Microsoft has used to open source a number of its developer technologies, including .NET and ASP.NET implementations and components.

Visual Studio for Mac will include IntelliSense and refactoring via the Roslyn Compiler platform. It will use MSBuild and the same debugger engines for Xamarin and .NET Core apps, as well as the same designers for Xamarin.iOS and Xamarin.Android.

Visual Studio 2017 for Windows also is relying on the "Roslyn" work to rearchitect the C# and Visual Basic compilers. The coming release includes enhancements in refactorings, code generation, code analysis, navigation, testing, and debugging, officials said.

Visual-Studio-2017-Install

Other Connect() announcements today included a preview of a new Visual Studio Mobile Center, and general availability of both Visual Studio Team Foundation server 2017 and Azure Application Insights.

Visual-Studio-2017-Install2

Visual Studio Mobile Center is a portal that is meant to help developers build, test, distribute, and monitor apps built in Objective-C, Swift, Java, Xamarin, and React Native for Android, iOS, and Windows devices. Documentation for the new Mobile Center is here.

Visual-Studio-2017-Install3

Samsung also is releasing a preview of Visual Studio Tools for the Tizen operating system, which will allow developers to build apps for Tizen running on Samsung TVs, wearables, mobile, and other IoT devices.

How to reset lost SA password in SQL Express

Overview

If you ever find yourself in a situation where you need to reset the sa password on a SQL Express instance then you are not alone. I recently inherited a PC from a previous developer that already had SQL Express installed. This normally wouldn’t be a bad thing, except in this case it was not setup in mixed mode and my logged in account had no sysadmin rights on the instance.

In this article I hope to enlighten you as to how to reset the sa password in SQL Express without having any sort of administrator rights to the SQL instance.

You will need to be somewhat comfortable with editing the registry, starting and stopping windows services and working with a command prompt.

Steps to SQL Express sysadmin access

In order to gain sysadmin access to the SQL instance there were a few things that I needed to accomplish. Here is the basic goals I needed to achieve:

  • Change the login method from Windows Authentication to Mixed mode
  • Enable the sa user account
  • Reset the password to the sa user account

Doesn’t seem like that daunting of a list does it? I didn’t think so either.

Change the login method

In order to change the login method I had to change a registry setting. Why, you ask? Because, I say, we don’t have sysadmin rights so we can’t just change the database properties using SSMS.

  • Open the registry editor
  • Navigate to…
    HKEY_LOCAL_MACHINE
       \SOFTWARE
          \Microsoft
             \Microsoft SQL Server
                \MSSQL.10.SQLEXPRESS
                   \MSSQLServer
    
  • Change the value of LoginMode from 1 to 2
  • Close the registry editor

One thing to note is I had a few different options under the “Microsoft SQL Server” branch so you may need to take an educated guess if yours is different.

Enable the sa user account and reset its password

I lumped these two into one section because the commands for them are entered at the same place.

  1. Open the Services applet in the Control Panel
  2. Find the “SQL Server (SQLEXPRESS)” entry and open its properties
  3. Stop the service
  4. Enter “-m” into the “Start parameters” field
  5. Start the service
  6. Open a Command Prompt
  7. Enter the command:
    osql -S PC_NAME\SQLEXPRESS -E

    Be sure to change PC_NAME to whatever your PC name is or you will get a big long message saying you messed up.

  8. At the next prompts enter the following commands:
    1> alter login sa enable
    2> go
    1> sp_password NULL,'new_password','sa'
    2> go
    1> quit
  9. Stop the “SQL Server (SQLEXPRESS)” service
  10. Remove the “-m” from the Start parameters field
  11. Start the service

At this point you should be able to login to SSMS using the sa user account and the new password you gave it.

Store and Ads to Deliver $189 Billion to Publishers in 2020

Mobile-App-Forecast-annual-net-to-publisher-revenue-app-monetization

Apps are increasingly becoming the go-to resource for communication, entertainment, shopping, productivity and more. As a result, the time consumers spend in apps has exploded.

Coupled with the growth of the global installed base of smartphones and tablets, this will set the stage for significant revenue growth. This expanding revenue opportunity will not be exclusive to the top apps and categories, but will be more widely spread across the app economy.

In order to fully capitalize on the app economy’s exceptional growth, publishers need to anticipate future market opportunities when planning for a variety of business scenarios, including product launches, performance goals, international expansion and portfolio management.

To help showcase the opportunities for publishers, we’ve published App Annie App Monetization Report: Publishers to Earn $189 Billion from Stores and Ads in 2020. Key insights include:

  • Combined worldwide in-app advertising and net-to-publisher app store revenue is forecast to grow by 270% — from $70 billion in 2015 to $189 billion in 2020.
  • Though games will continue to capture the majority of revenue, advertising will help apps (excluding games) increase their share through 2020.
  • In-app advertising and freemium will continue to dominate other business models and subscriptions will continue to be an increasingly important type of in-app purchase.
  • The Americas, APAC and EMEA will experience significant revenue growth from 2015 to 2020, with China driving APAC’s particularly strong growth.

Download the complete report from this site.

Xamarin Forms Components

Hello guys!

From today on Nuget there are 4 new components for Xamarin Forms created by me.

Happy coding!

Advertsing

125X125_06

Planet Xamarin

Planet Xamarin

Calendar

<<  July 2017  >>
MonTueWedThuFriSatSun
262728293012
3456789
10111213141516
17181920212223
24252627282930
31123456

View posts in large calendar

Month List