Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Delinda
Constraint Violating Yak Guru
315 Posts |
 Posted - 2009-08-31 : 23:35:49
|
| I've Ticketing Database in Server A. I want to move this Ticketing Database into Server B.In Server B, this Ticketing Database is a fresh data without any transaction except pre-loaded data such as Master Table data.Did any way to create this process into Installer or another good way? |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-01 : 06:42:37
|
| There are a few options:1. BCP / batch file2. Data Import/Export Wizard3. SSISHow many tables? What is the volume of data? Do you need to store the data in a source control system? |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-09-01 : 06:58:20
|
| You can always script a database if you want to just move schema and run the script on destination server.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2009-09-01 : 12:47:08
|
| Backup source database and restore on destination |
|
|
|
Delinda
Constraint Violating Yak Guru
315 Posts |
Posted - 2009-09-02 : 11:15:24
|
quote:
Originally posted by YellowBug
There are a few options:1. BCP / batch file2. Data Import/Export Wizard3. SSISHow many tables? What is the volume of data? Do you need to store the data in a source control system?
Yes, I need to store the data in a source control system. How? Any idea? |
|
|
|
|
|
|
Create Setup File into Installer