Author |
Topic  |
|
l2k man
New Member

United Kingdom
74 Posts |
Posted - 18 January 2013 : 04:17:21
|
I have just changed our domain name, so had to move the whole site to a new server. Apart from changing config to point to the new location, I haven't changed any scripts. I copied the database from the old server to the new one using SQL Server Management 2008. The import/export facility didn't copy over the primary keys, but otherwise all seemed OK. I have got the new site working OK, except there is nothing being read into T_VIEW_COUNT, it remains as Null. Any ideas where I should look to correct this? |
Edited by - l2k man on 18 January 2013 16:57:55 |
|
l2k man
New Member

United Kingdom
74 Posts |
Posted - 18 January 2013 : 04:43:01
|
Ah, found it. If anyone else needs to move SQL database, I found that some of the parameters are not carried over. In this case, under design of T_VIEW_COUNT I found under Column Properties/General/Default Value or Binding was blank. Having checked the original dbase, I put in ((0)) and now it works. btw, I did run setup after I had moved everything over. |
 |
|
|
Topic  |
|
|
|