Last post Jul 25, 2011 02:18 AM by necro_mancer
Jul 20, 2011 06:58 AM|FredS52|LINK
We have installed the asp.net membership tables, stored procedures, etc. on our development SQL server and we are now ready to deploy to production. Development server is Developer Edition version 10.0.2531, Production server is Standard Edition 10.50.1617
When we do our database compare it identifies differences between the table structures, etc., which I would like to resolve. What is the best way to make sure the tables structures are identical down to constraint identifiers?
Jul 21, 2011 02:44 AM|necro_mancer|LINK
This is the first time I heard that you can have two different table structure on different database system. I cannot see as to why you can have different structures, even though you develop it by using Developer Edition and Standard Edition
Would you please advise what sort of differences are they?
Jul 21, 2011 04:53 AM|FredS52|LINK
The constraint names are different like DF_aspnet_Ap_Appli_61045330, versus DF_aspnet_Ap_Appli_6B7EB447
For the aspnet_Membership table it reports ntext with a column length of 3000 on the development machine, and a length of 16 on the production machine. I realize that ntext has no length defined in the design and this is a quirk of the DBdiff software,
but it would be nice if it were not there.
Jul 25, 2011 02:18 AM|necro_mancer|LINK
would you please try to take a FULL backup of one db and restored it over to the other DB? Please keep me posted of any progress you made