Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #2085

Re: Easy way to copy database from MsSQL Express to MsSQL-Server?

Show all headers | View raw

Am 19.04.21 um 22:53 schrieb Erland Sommarskog:
> Tim Ritberg (tim@server.invalid) writes:
>> Can't login today. The server instance is a Linux MsSQL 15.
>> On Desktop is a (Express) SQL Server 2016 SP1.
>>
> 
> So the server is of a later version that the the Express instance. That's
> good, because then you can use BACKUP/RESTORE.
> 
> BACKUP DATABASE db TO DISK = 'C:\temp\backup.bak' WITH INIT
> 
> And then on the server:
> 
> RESTORE DATABASE db FROM DISK = '/path/backup.bak'
> WITH MOVE 'db' TO '<path>',
>       MOVE 'db_log' TO '<path>'
> 
> When it comes to the names that follow MOVE, these are the logical names of
> the devices. They often follow the pattern shown here, but this is not
> always the case. Run sp_helpdb on the database on the source server to
> see the names. They are in the first column of the second result set.
> 
> 
And what about users/permissions etc?

Tim

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Easy way to copy database from MsSQL Express to MsSQL-Server? Tim Ritberg <tim@server.invalid> - 2021-04-18 13:01 +0200
  Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Erland Sommarskog <esquel@sommarskog.se> - 2021-04-18 23:15 +0200
    Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Tim Ritberg <tim@server.invalid> - 2021-04-19 22:20 +0200
      Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Erland Sommarskog <esquel@sommarskog.se> - 2021-04-19 22:53 +0200
        Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Tim Ritberg <tim@server.invalid> - 2021-04-19 23:25 +0200
          Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Erland Sommarskog <esquel@sommarskog.se> - 2021-04-20 20:44 +0200
            Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Tim Ritberg <tim@server.invalid> - 2021-04-20 22:56 +0200
              Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Erland Sommarskog <esquel@sommarskog.se> - 2021-04-21 20:25 +0200
                Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Tim Ritberg <tim@server.invalid> - 2021-04-21 21:23 +0200
                Re: Easy way to copy database from MsSQL Express to MsSQL-Server? Erland Sommarskog <esquel@sommarskog.se> - 2021-04-22 21:20 +0200

csiph-web