Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deploying on a new server
Message
From
15/11/2004 13:36:22
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00961378
Message ID:
00961467
Views:
15
>If you've acces to both servers at the same time, you can use DTS to transfer data or you can use EM Copy Database Wizard to copy whole DB including data.
>The scripts from the thread above allow you to generate another scrip with INSER command that you can run on destination server after you creted tables. See http://www.mssqlcity.com/Scripts/ImpExp/DataAsInsertCommand.sql

Ok, now assuming we don't have access to the source server, this would then force me to install from a CD. On that CD, all the data will be there. Would the DTS approach still applicable?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform