21491 Posts in 5783 Topics by 2621 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 253 Views |
-
dev/build issue on MS SQL database
10 October 2011 at 11:54am
Hi there
I am developing a site on my local dev server running MySQL for a production site running MS SQL. Most things are going smoothly for the deployment to the MS SQL server end (except MS SQL doesn't allow the LIMIT function!?).
However I am getting an odd dev/build report each and every time I run it, even when nothing has been altered. It seems to want to change some column names as below. It doesn't throw an error, but I'm wondering if this is something I need to remedy? Any ideas?
Thanks, Jayne
Index File.SearchFields: changed to fulltext (Filename,Title,Content) (from fulltext (Title,Filename,Content))
...
Index Page_versions.Version: changed to (Version) (from unique (Version))
BlogEntry
Index BlogEntry_versions.Version: changed to (Version) (from unique (Version))
BlogTree
Index BlogTree_versions.Version: changed to (Version) (from unique (Version))
Index BlogTree_versions.SideBarID: changed to (SideBarID) (from unique (SideBarID))
NewsHolder
NewsPage
Index NewsPage_versions.Version: changed to (Version) (from unique (Version))
ErrorPage
Index ErrorPage_versions.Version: changed to (Version) (from unique (Version))
RedirectorPage
Index RedirectorPage_versions.Version: changed to (Version) (from unique (Version))
VirtualPage
Index VirtualPage_versions.Version: changed to (Version) (from unique (Version))
UserDefinedForm
Index UserDefinedForm_versions.Version: changed to (Version) (from unique (Version))
BlogHolder
Index BlogHolder_versions.Version: changed to (Version) (from unique (Version)) -
Re: dev/build issue on MS SQL database
19 October 2011 at 5:34pm
If it's blue then you don't need to worry too much about it. Likely the MSSQL engine isn't correctly detecting alterations so it won't hurt the data.
-
Re: dev/build issue on MS SQL database
19 October 2011 at 6:07pm
Thanks for that Willr - that's what I was hoping. Cheers, Y.
| 253 Views | ||
|
Page:
1
|
Go to Top |
