October 16, 2008 at 10:35 pm
Hi,
While loading the database to the client for demo / installations, is it good to generate scripts or load the physical database.
i want to load with some data. so just generate script will not work.
help me in this
Regards
Viji
October 17, 2008 at 5:37 am
The easiest way to do it is probably with a backup & restore.
However, if you're making lots of changes over time to the structure or the data, you may want to script everything and do a full tear down & rebuild each time. In my experience, if you're dealing with volatile data or structures, this is the easier way to work. But then, we're building our databases from source control already. If you're not doing that yet, it's a bit of a leap.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply