February 27, 2007 at 5:28 pm
I have created a ecommerce site using ASP .NET and SQL Server 2005 in Visual Studio 2005.
The web host I am using only has support for MS SQL 2000.
I created an SQL Script using SQL Server Management Sudio Express' script generator (for SQL 2000) to create the tables, stored procedures and user created functions.
I used sp_generate_inserts (Build 22) (Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.) to generate the insert statements to fill the tables.
No success.
I also sent the web host tech team my scripts, the mdf and ldf files and they have had zero success.
Its hard for me to troubleshoot as the Enterprise Manager the web host provides for DB manipulation does not generate any error messages, the scripts just dont work.
While talking to a guy at the web host he said it had something to do with the Identity columns not allowing inserts or something along that line, but the worthless Enterprise Manager provided by the server won't allow me to make the identity columns not identity columns.
Everything works fine on my local machine and quite frankly Im about ready to drop kick someone in the face. It has been a week of this. And my client is getting pretty impatient.
Does anyone have any suggestions?
Has anyone had any success transferring a MS SQL 2005 DB to a server with strictly 2000 support?
What is the best method for me to transfer this over?
I am desperated, ready to smash my laptop and ultimately Im sick of working on this f'n website all together. Not to mention dealing with the worthless tech support provided by my web host.
Thanx in advance for anything.
February 27, 2007 at 10:14 pm
Why don't you use SSIS/DTS to copy objects and data from 2005 to 2000...
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply