How to duplicate tables and/or db's, including all permissions, users, etc.?
Posted on 2008-06-23
Hi Friends :-)
I'm a Flash/Flex developer, crossing over into .NET web apps.
I can't stop the SQL server, and prefer not to take anything off-line.
I have admin on IIS, and sa on SQL.
There are about 50 dbs on this server, so I want to minimize impact.
I just want tables and sometimes entire db's copied with new names, but with all the same data and permissions, etc., so that I can do testing with web code, and not worry about trashing or changing anything critical.
Any solid references with lots of detail are especially appreciated. :-)