[dba-SQLServer] Schemas for separation of clients?

[Gustav Brock]

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