If you're going to a latest schema, you could use SQL Compare from Red Gate. There's an API for scripting, and you could compare to a backup file or even...

Glad to see everyone behaved, and yes, I had a great day on the slopes at Keystone.

Jeff Moden (1/26/2012)

I've not experienced any noticiable...

GilaMonster (1/26/2012)

I've had that. It was followed by almost R10 000 repair bill for replacing the gaskets in...

True, you can use views of synonyms. That might work, although performance wouldn't be great.

For dev/test, it's probably fine.

You have three choices

1. delete 30GB of data

2. move data to separate databases. Meaning either move a portion of data from each table to a new database

3.move certain tables to...

Is that a "yes"?

BTW,...

Why do you need to move to Express? I'm asking, so that I can try to see if there is something you can do.

The short answer is no, you need...

I would concur with Jared and Gail here. The licenses seem to read, to me, that you cannot use other systems for analysis or reporting of live data, but if...

Why do you want to reduce the file size to 20GB?

Second, if you have a 40GB file, with 1GB unallocated, then you have 39GB of data. If you need to...

I changed the question too, to note that the shrink runs shorter.

It's certainly a strange behavior, and one I'm not sure I like.

I think I'll refund all points for now.

Call MS. They do not document this stuff well, mostly I think to avoid people gaming the system.

AFAIK, you cannot use development stuff for production. They are fairly liberal on...

SQL Kiwi (1/24/2012)

I tried snowboarding once (in a supervised inside environment[/url]) and that was enough to convince me that I have no...

This help? http://www.sqlservercentral.com/Forums/Topic556439-146-1.aspx

Audit classes (as per Colleen) : http://msdn.microsoft.com/en-us/library/cc280663.aspx