[dba-SQLServer] Schemas for separation of clients?

[Mark Breen]

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
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>