[dba-SQLServer] Schemas for separation of clients?

[Gustav Brock]

Hi Mark

That's what I thought. But the straight backup complains that it is restoring to a different server (which is correct), then stops - and another method claims that it cannot restore to a 2005 or newer(!) version, which is nonsense but I binged that to be a way of telling you, that it will not backup data from a Standard version to an Express version.

I can copy the data, but then all indexes and relations are lost.

A third method (can't recall which at this confusing moment) stops because it cannot write the timestamps to read-only fields.

Do I really need to fire up the data migration Tool?

/gustav

________________________________________
Fra: dba-SQLServer <dba-sqlserver-bounces at databaseadvisors.com> på vegne af Mark Breen <marklbreen at gmail.com>
Sendt: 30. marts 2015 20:28
Til: Discussion concerning MS SQL Server
Emne: Re: [dba-SQLServer] Schemas for separation of clients?

Hello Gustav,

if your db is really the same version, it will simply restore a backup.  I
am 100 % sure about that.  SQL standard to sql express is perfectly fine.
I have done it many times.  As you probably know, you cannot restore a
newer version to an older version.

Can you try the backup and restore using standard sql server backup.



On 31 March 2015 at 00:21, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Mark
>
> How do you copy a database from an in-house SQL Server 2008 Standard to
> the hosted SQL Server 2008 Express?
> I can copy and create the schema, but have had no luck finding a method to
> copy either the data to the created schema or the complete database.
>
> I have used both SSMS 2008 on the AWS machine as well as SSMS 2012/2014 on
> my own machines.
>
> There has to be a simple and proven method.
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] På
> vegne af Mark Breen
> Sendt: 30. marts 2015 11:31
> Til: Discussion concerning MS SQL Server
> Emne: Re: [dba-SQLServer] Schemas for separation of clients?
>
> Hello Gustav
>
> I have played with RDS but mostly I use ec2.  For you I was suggesting ec2
> and SQL express.  Then you can have multiple dB's.
>
> Mark