ASPNetFAQ.com: What is ASP.NET?

Technology posts on ASP.NET, IIS, Windows (+ a little Linux), Cloud Servers, Hosting, and more!
  • Blog Home
Search the site...

SQL Server 2005 Export / Import Issues

Tweet
Share
0 Shares

We had a client run across some issues recently when they exported their SQL Server 2005 database from their old host and imported it into a new database at OrcsWeb. After spending quite a bit of time working with the client on why the application wouldn’t work, we tracked it down to a page on the site that tried to do an insert but was missing a key field. The client assured us that the same code worked elsewhere, so we continued troubleshooting for them. After a while we came across the idea to do a full audit and compare of their database hosted with OrcsWeb and the one at the old host. Well, come to find out, the databases weren’t the same.

But… wait… an export and then import were done directly through SQL so they should match! Yeah, you would think so, but there are apparently issues with SQL Server (at least in version 2005) where it can drop identity fields.

So with no identity set on certain fields in the new database, SQL Server was expecting that value to be provided. Since it wasn’t, the code barfed.

Here’s a link to a post someone else wrote about the issue:

http://rip747.wordpress.com/2007/10/01/sql-server-2005-import-export-reset-identity-keys-no-workaround-2005-sucks-period-the-end/

The workaround would be to get a full backup from the one server and then perform a full restore on the new server – that’ll assure the tables, data, and *all* settings are brought across for the migration.

I hope this helps someone else. Happy hosting!

More from my site

  • Handler "PHP5x_via_FastCGI" has a bad module "FastCgiModule" in its module listHandler "PHP5x_via_FastCGI" has a bad module "FastCgiModule" in its module list
  • User Isolation for Multiple FTP AcountsUser Isolation for Multiple FTP Acounts
  • Five Valuable Posts on IIS7 TopicsFive Valuable Posts on IIS7 Topics
  • Kendo UI Sample, ASP.NET Ajax Tutorial & MoreKendo UI Sample, ASP.NET Ajax Tutorial & More
  • How do I find my IP address in Ubuntu?How do I find my IP address in Ubuntu?
Tweet
Share
0 Shares

Comments are closed.

Proverbs 19:20

"Get all the advice and instruction you can, so you will be wise the rest of your life."

A Note On WordPress Hosting

Our main focus is of course .NET, but with a mix of Linux, virtualization, and other technologies. But if you're really looking for the best WordPress hosting specifically, read my WordPress host review to save yourself hassle AND money!




Recent Posts

  • What makes good web hosting?
  • jQuery Mobile C# ASP.NET and N5 Networks Software Repository
  • Open Source Bug Tracking Software and the Orchard Project
  • ASP.NET Development with Dreamweaver MX: Visual QuickPro Guide
  • Kendo UI Sample, ASP.NET Ajax Tutorial & More

Tags

ASP.NET Automation centos CMS css cytanium Development/Coding Email gmail Hosting htaccess http https IIS javascript Learning Linux logparser MySQL nginx openssl OrcsWeb performance PowerShell redirect RHEL security server SherWeb smtp SQL/Databases ssl System Administration telnet terminal tip Troubleshooting Ubuntu virtualization Visual Studio web farm web hosting Windows windows server Wordpress

Categories

  • ASP.net development
  • Development/Coding
  • Hosting
  • IIS (Internet Information Services)
  • SQL/Databases
  • System Administration
  • Virtualization
(c) ASPNETFAQ.com