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

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

Path	csiph.com!weretis.net!feeder8.news.weretis.net!feeder5.news.weretis.net!news.tota-refugium.de!.POSTED!not-for-mail
From	Tim Ritberg <tim@server.invalid>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Easy way to copy database from MsSQL Express to MsSQL-Server?
Date	Wed, 21 Apr 2021 21:23:30 +0200
Message-ID	<s5pu3i$ogt$1@tota-refugium.de> (permalink)
References	<s5h3hp$o41$1@tota-refugium.de> <XnsAD10ECA229243Yazorman@127.0.0.1> <s5koma$7vs$1@tota-refugium.de> <XnsAD11E8F149422Yazorman@127.0.0.1> <s5ksfm$9rj$1@tota-refugium.de> <XnsAD12D3032F167Yazorman@127.0.0.1> <s5nf69$ddl$1@tota-refugium.de> <XnsAD13CFD453DC9Yazorman@127.0.0.1>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding	7bit
Injection-Date	Wed, 21 Apr 2021 19:23:30 -0000 (UTC)
Injection-Info	tota-refugium.de; logging-data="25117"; mail-complaints-to="abuse@news.tota-refugium.de"
User-Agent	Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.7.1
Cancel-Lock	sha1:/hg92bbiqDwgg6nTiXYF6t5AZdQ=
Content-Language	de-DE
In-Reply-To	<XnsAD13CFD453DC9Yazorman@127.0.0.1>
X-User-ID	eJwFwYkRwDAIA7CV+GzIOD2T7D9CJSSd6iJYeHh3HI4eT01U5J44XSrd8PbVcr+xhqwpO/kD/X4QFw==
Xref	csiph.com comp.databases.ms-sqlserver:2089

Show key headers only | View raw

Am 21.04.21 um 20:25 schrieb Erland Sommarskog:
> Tim Ritberg (tim@server.invalid) writes:
>> I guess, I would use admin account.
>>
> 
> Yeah, that is what I would expect too. And in that case, you don't need
> to worry about permissions. In SQL Server at least. Possibly there can
> be issues in the file system.
> 

But this application should not use an admin account, so I have to 
transfer user from express to server.

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