[dba-SQLServer] Manually recreate database structure

jwcolby jwcolby at colbyconsulting.com
Sat Jul 23 07:53:04 CDT 2011


Never mind, I found it.  When run, the script generated about a billion errors but it did apparently 
build the tables.

John W. Colby
www.ColbyConsulting.com

On 7/23/2011 8:43 AM, jwcolby wrote:
> I am building the scripts one by one by clicking on the table and right clicking "script table as".
> Is there some way to script the whole shebang at once time into a single script?
>
> John W. Colby
> www.ColbyConsulting.com
>
> On 7/23/2011 2:55 AM, Arthur Fuller wrote:
>> Yes, or alternatively re-order the script's execution sequence to populate
>> all the lookup tables first, and only then populate the main tables.
>>
>> FWIW, I agree that these MS tools ought to do a far better job at this, and
>> understand in which order the tables ought to be created.
>>
>> A.
>>
>> On Sat, Jul 23, 2011 at 1:40 AM, jwcolby<jwcolby at colbyconsulting.com>wrote:
>>
>>> I have a database designed on SQL Server 2008 Express which is a later
>>> version (10.50) than my full version (10.0). I cannot backup and restore
>>> backwards nor can I detach / attach.
>>>
>>> Thus I am scripting as create each table and copying the script to a new
>>> database (same name) on the older software version Server. My problem is
>>> that the scripts have constraints which are PK/FK pairs. Each table has
>>> these constraints but one half of the constraint will always be missing as I
>>> run these scripts. Is there a way to tell SQL server to create but ignore
>>> the constraints as I create the tables and even as I load the tables with
>>> the existing data and then "turn on" the constraints at the very end?
>>>
>>> Or do I need to move the constraint SQL into a separate query, create the
>>> tables, load the data and then create the constraints at the end?
>>>
>> _______________________________________________
>> dba-SQLServer mailing list
>> dba-SQLServer at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>> http://www.databaseadvisors.com
>>
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list