MSSQL 2005 import/export question

SMS enable your application via Clickatell’s fast, simple and reliable API's, built to integrate with any system. Click here to learn more.

Flash Website Builder- Trendy Site Builder is a Flash Site Building tool that helps users build stunning websites.

Check Out Custom Custom Logo Design by LogoBee. Website Design and Free Logo Templates available.

		CodingForums.com > :: Server side development > MySQL > Other Databases
MSSQL 2005 import/export question

Before you post, read our: Rules & Posting Guidelines

Enjoy an ad free experience by logging in. Not a member yet? Register.

12-20-2007, 12:03 PM	PM User \| #1
123bargains New to the CF scene Join Date: Dec 2007 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts	MSSQL 2005 import/export question Hello, I wanted to ask a question on MSSQL. I am trying to move a MSSQL database from SQL 2000 to SQL 2005. I used the Server Management Studio to Import the database from the old server. It seemed to work fine and the data and tables imported. However, it seems the properties such as Identity Values, Column Defaults, Indexes for the tables were not copied. Is there any way to get the whole database including those properties to be copied so I don't have to go in each table and add them? Any suggestion would be appreciated. Thanks in advance.

Bookmarks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT +1. The time now is 04:25 PM.