How to create SQL Server Express DB from SQL Server DB

Posted by jeff on Stack Overflow See other posts from Stack Overflow or by jeff
Published on 2009-09-17T13:37:21Z Indexed on 2010/03/08 3:51 UTC
Read the original article Hit count: 937

I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it.

We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization stuff and at this point don't know how to run SSIS. We are a C# shop and a little code is ok. Like using the C# bulk import stuff, but that won't create the schema.

Suggestions?

© Stack Overflow or respective owner

Related posts about sql

Related posts about tsql