ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. Tags
    3. t-sql
    Log in to post
    • All categories
    • scottalanmiller

      Restoring a Windows MS SQL Server Database to Linux With Move SQLCMD
      IT Discussion • sql server 2012 sql server 2014 sql server 2016 sql server 2017 sql server 2019 ubuntu linux database t-sql • • scottalanmiller

      3
      2
      Votes
      3
      Posts
      211
      Views

      scottalanmiller

      @jaredbusch said in Restoring a Windows MS SQL Server Database to Linux With Move SQLCMD:

      @scottalanmiller I have not had to do that before with a normal backup to a .bak and then restore. Not some an place move like it seems you are doing.

      Happens if going to a space with a different storage layout. If you are coming from Linux you are probably fine. But Windows injects the drive letter into the path (obviously) and so going from one machine to another that doesn't keep identical storage path names causes the issue.

    • garak0410

      SQL Question - Removing Part Of A Field
      IT Discussion • lightswitch sql server sql t-sql • • garak0410

      18
      0
      Votes
      18
      Posts
      3173
      Views

      JaredBusch

      @NetworkNerd said:

      If I understand correctly, that code snippet is only for a validation that will be run against the Phone1 field. Are you just trying to throw up a validation error on a web page or within an application if a proper phone number is not entered in the PHONE1 field?

      He wants to extract out the first 10 digits of the PHONE1 field and present them to the application / page as the phone number so that the native regional formatting of 10 digit TN handles it correctly.