Thursday, March 24, 2005

IT: SQL view migration

I love SQL. It's an awesome tool. And SQL 2000 blows me away with how easy it makes commonly used SQL tasks. Unfortunately, one of its nifty data import wizards bit me when copying from dev SQL box to the live SQL box. Apparently, when you import a view, it just makes a table of that view. Yup, just a bunch of static columns - nothing referring to the original data! Bad. I had to go in by hand and copy the SQL code view by view to rebuild the live views. Being an SQL newb, the expectation is there's a much more graceful way to do this. So far though, the recommendation is: be careful!


Post a Comment

<< Home