Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
If you have SP3.2 all you need to run are the scripts in the /bvadmin/sql/SP4 folder
|
|
|
|
|
|
Rank: Member
Joined: 11/17/2008(UTC)
Posts: 6
|
Manual Scripts ran Fine thanks... |
|
|
|
|
|
|
Rank: Member
Joined: 8/8/2007(UTC)
Posts: 298
|
Originally Posted by: "Marcus" 
If you have SP3.2 all you need to run are the scripts in the /bvadmin/sql/SP4 folder
Again, what is the proper way to run the script s? |
Dan
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
Dan,
I suspect most people use SQL Server Management Studio to run the scripts. You can get the Express version from Microsoft for free. In broad strokes, you use it like this:
1. Close the store.
2. Make a backup of the database (you may be able to use Management Studio to make the backup...but if you are on a shared server, you will probably need to ask your host to make the backup for you).
3. Make sure the backup exists. It would be heart wrenching to lose your data.
4. Launch Management Studio and connect to your database.
5. Select File > Open > File from the menu and open the first script you are going to run.
6. Click on the Execute button.
Repeat steps 5 and 6 for each script in the folders. (From memory) Marcus wrote to run the schema scripts first, then the data scripts.
7. Finish the upgrade and then test your store.
8. If the tests succeed, open the store.
9. Done. |
|
|
|
|
|
|
Rank: Member
Joined: 8/8/2007(UTC)
Posts: 298
|
Thanks Andy, that is what i needed. |
Dan
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Sorry Dan, didn't understand that you were asking how to "run" the scripts. Thanks Andy for the detailed response.
|
|
|
|
|
|
Rank: Member
Joined: 11/9/2008(UTC)
Posts: 17
|
Hi,
I have installed BV5_4 and run the scripts in full folder BVAdmin\BVSql\Full and in BVAdmin\BVSql\SP4, when I have run the "SchemaScript.sql" .. I have got this error many times through the execution:
[blue] Cannot find the object "dbo.bvc_KitPartGroup" because it does not exist or you do not have permissions.[/blue]
I have checked the tables .. and there is no table with "bvc_KitPartGroup" name, and also the createTable file in Full folder has not any create or alter statement for this table.
Any idea ???
Thanx for help.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.