Home Forums SQL Server 7,2000 Strategies Copying Tables structure from SQL 2000 to Local database. RE: Copying Tables structure from SQL 2000 to Local database.
Greg Charles
SSC-Forever
Points: 45403
More actions
December 30, 2009 at 9:11 am
#1097509
Is your local database that includes the new table in SQL 2005 or SQL 2000? Since you posted in the Integration Services forum, I could assume that it's in SQL 2005 and recommend that you use the Import Wizard in Management Studio.
Greg