Hi, having trouble upgrading v1.9 db to 2.0, here are the results of running the script, once it completes with these errors then there are no tables left in the database
Thx
-Keith
Msg 208, Level 16, State 1, Line 3
Invalid object name 'Customer'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Address'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'Country'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'StateProvince'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'ShippingMethod'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'TaxCategory'.
Msg 208, Level 16, State 1, Line 8
Invalid object name 'Setting'.
moving downloads
moving download. ID 11
Msg 1088, Level 16, State 11, Line 18
Cannot find the object "Download" because it does not exist or you do not have permissions.
moving pictures
moving picture. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "Picture" because it does not exist or you do not have permissions.
moving languages
Msg 208, Level 16, State 1, Line 7
Invalid object name 'Language'.
moving campaigns
moving campaign. ID 1
Msg 1088, Level 16, State 11, Line 22
Cannot find the object "Campaign" because it does not exist or you do not have permissions.
moving countries
moving country. ID 1
Msg 208, Level 16, State 1, Line 24
Invalid object name 'Country'.
moving states
moving state. ID 4
Msg 208, Level 16, State 1, Line 19
Invalid object name 'StateProvince'.
moving affiliates
moving customer roles
moving customer role. ID 1
Msg 208, Level 16, State 1, Line 22
Invalid object name 'CustomerRole'.
moving customers
moving customer. ID 1
Msg 1088, Level 16, State 11, Line 23
Cannot find the object "Customer" because it does not exist or you do not have permissions.
moving customer addresses
moving addresses. ID 2
Msg 208, Level 16, State 1, Line 22
Invalid object name 'Address'.
moving blog posts
moving blog post. ID 1
Msg 1088, Level 16, State 11, Line 20
Cannot find the object "BlogPost" because it does not exist or you do not have permissions.
moving blog comments
moving news items
moving news item. ID 9
Msg 1088, Level 16, State 11, Line 20
Cannot find the object "News" because it does not exist or you do not have permissions.
moving news comments
moving polls
moving poll answers
moving poll voting records
moving forum groups
moving forum group. ID 2
Msg 1088, Level 16, State 11, Line 17
Cannot find the object "Forums_Group" because it does not exist or you do not have permissions.
moving forums
moving forum. ID 2
Msg 1088, Level 16, State 11, Line 21
Cannot find the object "Forums_Forum" because it does not exist or you do not have permissions.
moving forum topics
moving forum posts
moving forum subscriptions
moving private messages
moving newsletter subscriptions
moving newsletter subscription. ID 1
Msg 208, Level 16, State 1, Line 24
Invalid object name 'NewsLetterSubscription'.
moving queued emails
Msg 208, Level 16, State 1, Line 15
Invalid object name 'Setting'.
moving shipping methods
moving shipping method. ID 1
Msg 208, Level 16, State 1, Line 24
Invalid object name 'ShippingMethod'.
moving tax categories
moving tax category. ID 6
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "TaxCategory" because it does not exist or you do not have permissions.
moving categories
moving category. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "Category" because it does not exist or you do not have permissions.
moving localized categories
moving manufacturers
moving manufacturer. ID 1
Msg 1088, Level 16, State 11, Line 22
Cannot find the object "Manufacturer" because it does not exist or you do not have permissions.
moving localized manufacturers
moving product tags
moving product tag. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "ProductTag" because it does not exist or you do not have permissions.
moving products
moving product. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "Product" because it does not exist or you do not have permissions.
moving localized products
moving related products
moving related product. ID 0
Msg 208, Level 16, State 1, Line 25
Invalid object name 'RelatedProduct'.
moving crosssell products
moving crosssell product. ID 1
Msg 208, Level 16, State 1, Line 25
Invalid object name 'CrossSellProduct'.
moving specification attributes
moving localized specification attributes
moving specification attribute options
moving localized specification attribute option
moving checkout attributes
moving localized checkout attributes
moving checkout attribute values
moving localized checkout attribute value
moving product variants
moving product variant. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "ProductVariant" because it does not exist or you do not have permissions.
moving localized product variants
moving product attributes
moving product attribute. ID 2
Msg 1088, Level 16, State 11, Line 23
Cannot find the object "ProductAttribute" because it does not exist or you do not have permissions.
moving localized product attribute
moving product variant attributes
moving product variant attribute. ID 1
Msg 1088, Level 16, State 11, Line 25
Cannot find the object "ProductVariant_ProductAttribute_Mapping" because it does not exist or you do not have permissions.
moving product variant attribute values
moving product variant attribute value. ID 1
Msg 1088, Level 16, State 11, Line 24
Cannot find the object "ProductVariantAttributeValue" because it does not exist or you do not have permissions.
moving localized product variant attribute value
moving product variant attribute combinations
moving tier prices
moving discounts
moving orders
moving order. ID 104
Msg 208, Level 16, State 1, Line 103
Invalid object name 'Address'.
moving order product variants
moving order product variant. ID 1
Msg 208, Level 16, State 1, Line 25
Invalid object name 'OrderProductVariant'.
moving order notes
moving order note. ID 1
Msg 208, Level 16, State 1, Line 24
Invalid object name 'OrderNote'.
moving discount usage history
moving gift cards
moving gift card usage history
moving recurring payments
moving recurring payment history
moving return requests
moving reward points history
moving product reviews
moving product review helpfulness
updating product review totals
product review total. ID 1
Msg 208, Level 16, State 1, Line 43
Invalid object name 'Product'.
