Copy of SQLServer software

Does anybody know where a copy of the MS-SQLServer software is posted?"Curt" <dkdkdk@.dkdkdk.dkd> wrote in message
news:Xns93C7596DBAD52curtsympaticoca@.207.35.177.13 4...
> Does anybody know where a copy of the MS-SQLServer software is posted?

Umm, you can go to http://www.microsoft.com/sql/evalua...ial/default.asp
and get a trial version.

Other than that, you have to purchase it.sqlsql

Copy from server to server

I work with sqlServer Y2K and I want to create a programme to copy a full
database from a server to and other.
I want to write a programme to do so.
So is it possible to make this copy with SQL DMO or SQL Transac ?
Is there a function like "copy database (src,destination)" .'
Thanks for Help
Regards
Christophe.You could use BACKUP and RESTORE commands to backup a database on one server
and restore it onto another.
You could also use Copy Database Wizard.
See SQL Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"meynet" <meynet@.csprogramme.com> wrote in message
news:bkbl5s$s6e$1@.news-reader1.wanadoo.fr...
I work with sqlServer Y2K and I want to create a programme to copy a full
database from a server to and other.
I want to write a programme to do so.
So is it possible to make this copy with SQL DMO or SQL Transac ?
Is there a function like "copy database (src,destination)" .'
Thanks for Help
Regards
Christophe.|||I have already tried it.
The problem is that you must have (2*size of database)Mdb free on your
machine !
1 size for backup
1 size for database to restore...
Is there no other way ?
Thanks
Christophe
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> a écrit dans le message de
news:uvQ5TPbfDHA.3324@.TK2MSFTNGP11.phx.gbl...
> You could use BACKUP and RESTORE commands to backup a database on one
server
> and restore it onto another.
> You could also use Copy Database Wizard.
> See SQL Server Books Online for more information.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> What hardware is your SQL Server running on?
> http://vyaskn.tripod.com/poll.htm
>
>
> "meynet" <meynet@.csprogramme.com> wrote in message
> news:bkbl5s$s6e$1@.news-reader1.wanadoo.fr...
> I work with sqlServer Y2K and I want to create a programme to copy a full
> database from a server to and other.
> I want to write a programme to do so.
> So is it possible to make this copy with SQL DMO or SQL Transac ?
> Is there a function like "copy database (src,destination)" .'
> Thanks for Help
> Regards
> Christophe.
>
>|||Great ! I will have a look à this DTS sample !
Thanks a lot
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> a écrit
dans le message de news:O7qD9SbfDHA.3104@.TK2MSFTNGP11.phx.gbl...
> There are many possibilities. You can use Backup and Resttore T-SQL
> commands. ou can use sp_detach_db, copy the files and sp_attach_db
> procedure. You can use DTS object model - there is even a sample app
called
> DTSCopyDatabase included in examples that can be installed from the SQL
> Server CD.
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "meynet" <meynet@.csprogramme.com> wrote in message
> news:bkbl5s$s6e$1@.news-reader1.wanadoo.fr...
> > I work with sqlServer Y2K and I want to create a programme to copy a
full
> > database from a server to and other.
> > I want to write a programme to do so.
> > So is it possible to make this copy with SQL DMO or SQL Transac ?
> > Is there a function like "copy database (src,destination)" .'
> >
> > Thanks for Help
> > Regards
> >
> > Christophe.
> >
> >
>

copy DTS from a user to another

Hi,
I have some local packages that are owned by the old sqlserver dba.I'm not
able to see them, nor to save them with my user (i have granted the system
administrator role).
I want to see these packages and move them to a new user.
How can I do this?
Thanks in advance,If you are trying to change the owner of these packages, then you can use
the undocumented procedure, sp_reassign_dtspackageowner.
For details refer to: http://www.sqldts.com/?212
http://support.microsoft.com/?kbid=247052
Anith|||Hi,
I saved the DTS package as my user but I'm still not able to edit them.
Is it possible that there's a password?
Thanks,
Tarek
"Anith Sen" wrote:

> If you are trying to change the owner of these packages, then you can use
> the undocumented procedure, sp_reassign_dtspackageowner.
> For details refer to: http://www.sqldts.com/?212
> http://support.microsoft.com/?kbid=247052
> --
> Anith
>
>sqlsql

Copy Database Wizard Problems

Hi,
I am trying to use the copy database wizard to copy a database from SQL
server 2000 to SQL Server 2005 on the same machine. When I run it, it fails
on the create package step with error message "Error loading type
library/DLL". The first two steps (Add log for package and add tasks for
transfering database objects) are sucessful. What does this error message
means? How can I correct it?
Thanks,
JimHello Jim,
I would like to know more detailed information about your environment so
that I can provide more troubleshoot steps.
1. What's your OS version and SQL Server version?
2. Have you applied latest Service pack for the Sql server and Windows OS?
3. Are you using the 64bit OS?
I would also like for you to check if the following registry key is present
or
not. If so please export it and send it to me:
HKCR\Wow6432Node\ " "
In here search for a key with TypeLib GUID =
{D1D9A51E-B4FE-420B-97B1-28A383EF9168} >
If the key is present proceed to try registering the dlls below as
follows.
PLEASE PERFORM IN THE ORDER SPECIFIED:
Regsvr32 /u "C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\DTS.dll"
Regsvr32 /u "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll"
Regsvr32 "C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\DTS.dll"
Regsvr32 "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll"
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Jim
I assume this is from SQL 2000 to SQL 2005, have you tried running this from
SQL 2005 instead. Will the same thing happen if you save this as a package
and then run the package?
John
"Jim Zhao" wrote:

> Hi,
> I am trying to use the copy database wizard to copy a database from SQL
> server 2000 to SQL Server 2005 on the same machine. When I run it, it fail
s
> on the create package step with error message "Error loading type
> library/DLL". The first two steps (Add log for package and add tasks for
> transfering database objects) are sucessful. What does this error message
> means? How can I correct it?
> Thanks,
> Jim|||Hi
If using SQL 2005 this may help! http://support.microsoft.com/kb/918222/
John
"John Bell" wrote:
[vbcol=seagreen]
> Hi Jim
> I assume this is from SQL 2000 to SQL 2005, have you tried running this fr
om
> SQL 2005 instead. Will the same thing happen if you save this as a package
> and then run the package?
> John
> "Jim Zhao" wrote:
>|||Jim Zhao wrote:
> Hi,
> I am trying to use the copy database wizard to copy a database from SQL
> server 2000 to SQL Server 2005 on the same machine. When I run it, it fail
s
> on the create package step with error message "Error loading type
> library/DLL". The first two steps (Add log for package and add tasks for
> transfering database objects) are sucessful. What does this error message
> means? How can I correct it?
> Thanks,
> Jim
You might consider doing yourself a favor by doing a backup/restore to
"copy" your database, instead of using this wizard... Easier, faster,
and you can TROUBLESHOOT it if it doesn't work...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.

Copy Database Wizard

I am attempting to use the CDW, to copy a database on my
laptop running SQL server 2000 PE to a server running SQL
Server 2000 standard edition. I think that I have set
all of the appropriate permissions/authentications etc.
I have run it both from EM and the command line but it
fails to copy the source .mdf file. All other function
execute properly ie the share is created, single user
mode invoked, etc etc. I have tried changing the name of
the destination file etc and it still results in a
failure to copy the source file error. Is this yet
another limitation of the PE or am I not doing something
correctly?
Thanks
The copy database wizard uses detach, copy and attach, and there aren't any
issues going up a version that I know of (going down is different if EG you
used partitioned views then downgraded to Personal Edition):
http://www.winnetmag.com/Articles/Ar...91/pg/2/2.html
http://support.microsoft.com/default...;en-us;q268361
Can you try detaching manually, making a copy of the file, copying the file
over to the share on the EE then attaching manually.
Hopefully this should establish the point of error.
HTH,
Paul Ibison
|||Will give it a try, thanks
>--Original Message--
>The copy database wizard uses detach, copy and attach,
and there aren't any
>issues going up a version that I know of (going down is
different if EG you
>used partitioned views then downgraded to Personal
Edition):
>http://www.winnetmag.com/Articles/Ar.../21391/pg/2/2.
html
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q268361
>Can you try detaching manually, making a copy of the
file, copying the file
>over to the share on the EE then attaching manually.
>Hopefully this should establish the point of error.
>HTH,
>Paul Ibison
>
>.
>
|||That worked, thanks[vbcol=seagreen]
>--Original Message--
>Will give it a try, thanks
>and there aren't any
>different if EG you
>Edition):
..
>html
>us;q268361
>file, copying the file
>.
>

copy database from web host to local?

Hi,
I also posted this question in sqlserver.DTS because I'm not sure where it
should go.
I'm trying to restore my local db from the one in my web host. I asked the
web host for help, and the only help they can offer is that: "Use SQL Server
Integrated Services (SSIS), which is integrated with the commercial version
of SQL Server Management Studio Express." I don't know what that means.
I also tried the DTSWizard.exe, but it only copies the data. It leaves out
my relationships, the keys, the SPs, etc...
What's the best way to copy a database from one sever to the other so that
everything is included?
Both are sql server 2005, and I want to copy from my web host to my local
server.
Thanks.
VMI (VMI@.discussions.microsoft.com) writes:
> I also posted this question in sqlserver.DTS because I'm not sure where it
> should go.
> I'm trying to restore my local db from the one in my web host. I asked
> the web host for help, and the only help they can offer is that: "Use
> SQL Server Integrated Services (SSIS), which is integrated with the
> commercial version of SQL Server Management Studio Express." I don't
> know what that means.
Well, Integration Services is not included in Express as far as I know.
Probably what they have in mind is the Copy Database Wizard, but you
would need to cough up around 50 USD for Developer Edition to get it.
Problem, though is that you would have to use the SMO method, which is
not very reliable.

> I also tried the DTSWizard.exe, but it only copies the data. It leaves out
> my relationships, the keys, the SPs, etc...
You can use the scripting capabilities in SSMS Express to script the
database, and then copy the data separately.
What you really should have done is do have all your database definition
under version control.

> What's the best way to copy a database from one sever to the other so that
> everything is included?
BACKUP/RESTORE, but that option is not likely to be available in
your situation.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Copy database from SqlServer 2000 to 2005

Hi;
How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
Server 2000 instances we do a backup/restore but 2005 won't do a restore of a
2000 backup.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
David Thielen wrote:
> Hi;
> How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
> Server 2000 instances we do a backup/restore but 2005 won't do a restore of a
> 2000 backup.
>
Sure it will. You can restore a 2000 backup to a 2005 server, but you
can't go the other way.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||We migrated all of our databases from 2000 to 2005 last year - my
memory isn't very clear now but I believe we did detach/reattach of the
database files. Basically you just copy over the ldf, mdf and ndf files
to the new server, then attach them through 2005 management studio,
making sure to specify the new file locations on the new server...
David Thielen wrote:
> Hi;
> How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
> Server 2000 instances we do a backup/restore but 2005 won't do a restore of a
> 2000 backup.
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm
|||yes, the other posters are correct - you can restore a 2000 db on 2005,
just not the other way around
also keep in mind, once you restore the db's you can change the
compatibility of a given database to match that of 2005, as the
compatibility will be 2000 by default (however be careful when doing
this as you may lose old functionality you may still need)
there is a database upgrade advisor tool available from microsoft,
avail as a download - probably best to run this first before changing
the db compatibility, esp on a production machine
just my 2 cents
MC wrote:[vbcol=seagreen]
> What do you mean wont do a restore of 2000 backup. It should, I did it more
> then a few times. You cant restore 2005 backup on 2000...
>
> MC
>
> "David Thielen" <thielen@.nospam.nospam> wrote in message
> news:7CBA4B6A-BAC8-44D9-9152-637A5D6153FD@.microsoft.com...

Copy database from SqlServer 2000 to 2005

Hi;
How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
Server 2000 instances we do a backup/restore but 2005 won't do a restore of
a
2000 backup.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htmDavid Thielen wrote:
> Hi;
> How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
> Server 2000 instances we do a backup/restore but 2005 won't do a restore o
f a
> 2000 backup.
>
Sure it will. You can restore a 2000 backup to a 2005 server, but you
can't go the other way.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||We migrated all of our databases from 2000 to 2005 last year - my
memory isn't very clear now but I believe we did detach/reattach of the
database files. Basically you just copy over the ldf, mdf and ndf files
to the new server, then attach them through 2005 management studio,
making sure to specify the new file locations on the new server...
David Thielen wrote:
> Hi;
> How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
> Server 2000 instances we do a backup/restore but 2005 won't do a restore o
f a
> 2000 backup.
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm|||What do you mean wont do a restore of 2000 backup. It should, I did it more
then a few times. You cant restore 2005 backup on 2000...
MC
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:7CBA4B6A-BAC8-44D9-9152-637A5D6153FD@.microsoft.com...
> Hi;
> How can I copy a database from SqlServer 2000 to 2005? Copying between Sql
> Server 2000 instances we do a backup/restore but 2005 won't do a restore
> of a
> 2000 backup.
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm
>|||yes, the other posters are correct - you can restore a 2000 db on 2005,
just not the other way around
also keep in mind, once you restore the db's you can change the
compatibility of a given database to match that of 2005, as the
compatibility will be 2000 by default (however be careful when doing
this as you may lose old functionality you may still need)
there is a database upgrade advisor tool available from microsoft,
avail as a download - probably best to run this first before changing
the db compatibility, esp on a production machine
just my 2 cents
MC wrote:[vbcol=seagreen]
> What do you mean wont do a restore of 2000 backup. It should, I did it mor
e
> then a few times. You cant restore 2005 backup on 2000...
>
> MC
>
> "David Thielen" <thielen@.nospam.nospam> wrote in message
> news:7CBA4B6A-BAC8-44D9-9152-637A5D6153FD@.microsoft.com...

Copy database from one server to other

We had two physical SQL servers and copying one database using the wizard to
the other sqlserver was easy because both services used the same domain
account. Now i will have to copy databases from one server to another
outside the domain. This means they will have seperate logins for the
sqlserver service. how can i then use the copy database wizard? It fails
because it can't create a file on the ditination server'
does this mean i have to use log shipping or use a script and then copy just
data'
thanks.You can use backup/restore or sp_attachdb, sp_detachdb. You will have to
manually script out the logins. See this page for more info:
http://support.microsoft.com/defaul...kb;en-us;246133
Ray Higdon MCSE, MCDBA, CCNA
--
"Richard K." <google@.walkersca.com> wrote in message
news:uCR%23ry98DHA.3404@.TK2MSFTNGP09.phx.gbl...
> We had two physical SQL servers and copying one database using the wizard
to
> the other sqlserver was easy because both services used the same domain
> account. Now i will have to copy databases from one server to another
> outside the domain. This means they will have seperate logins for the
> sqlserver service. how can i then use the copy database wizard? It fails
> because it can't create a file on the ditination server'
> does this mean i have to use log shipping or use a script and then copy
just
> data'
> thanks.
>

Copy database from one server to other

We had two physical SQL servers and copying one database using the wizard to
the other sqlserver was easy because both services used the same domain
account. Now i will have to copy databases from one server to another
outside the domain. This means they will have seperate logins for the
sqlserver service. how can i then use the copy database wizard? It fails
because it can't create a file on the ditination server'
does this mean i have to use log shipping or use a script and then copy just
data'
thanks.You can use backup/restore or sp_attachdb, sp_detachdb. You will have to
manually script out the logins. See this page for more info:
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Richard K." <google@.walkersca.com> wrote in message
news:uCR%23ry98DHA.3404@.TK2MSFTNGP09.phx.gbl...
> We had two physical SQL servers and copying one database using the wizard
to
> the other sqlserver was easy because both services used the same domain
> account. Now i will have to copy databases from one server to another
> outside the domain. This means they will have seperate logins for the
> sqlserver service. how can i then use the copy database wizard? It fails
> because it can't create a file on the ditination server'
> does this mean i have to use log shipping or use a script and then copy
just
> data'
> thanks.
>

Copy database from MSDE to SqlServer

Is there any easy way to copy a database from MSDE to SQLServer. MSDE is on
the test server and we would like to copy the whole database, table data,
structure and stored procedures.
"Chris Kennedy" <nospam@.nospam.co.uk> wrote in message
news:OM4$mapQEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Is there any easy way to copy a database from MSDE to SQLServer. MSDE is
on
> the test server and we would like to copy the whole database, table data,
> structure and stored procedures.
>
Use the copy objects wizard in DTS within Enterprise Manager (if they can
see each other over the network
or
Stop the MSDE services. Copy the mdb file to the SQL Server. Use the
SP_attache_single_file_db stored procedure to attch it to the new database.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004
|||Hi,
There are 2 options:-
1. Detach and Attach database
2. Backup and Restore the database
1. Detach and Attach
a. Use SP_DETACH_DB to detach the MDF and LDF files
b. Copy the files to Destination server
c. Use SP_ATTACH_DB to attach the databases
(Refer books online for information)
2. Backup and Restore
a. Backup the source databases using BACKUP DATABASE command
b. Copy the .BAK files to destination
c. Restore the database using RESTORE DATABASE command
If you have only 1 or 2 users to syncronize then use the procedure
sp_change_users_login (Refer books online)
If you have more users then; Have a look into the below link for
information.
http://www.databasejournal.com/featu...le.php/2228611
Thanks
Hari
MCDBA
"Chris Kennedy" <nospam@.nospam.co.uk> wrote in message
news:OM4$mapQEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Is there any easy way to copy a database from MSDE to SQLServer. MSDE is
on
> the test server and we would like to copy the whole database, table data,
> structure and stored procedures.
>

Copy database from MSDE to SqlServer

Is there any easy way to copy a database from MSDE to SQLServer. MSDE is on
the test server and we would like to copy the whole database, table data,
structure and stored procedures."Chris Kennedy" <nospam@.nospam.co.uk> wrote in message
news:OM4$mapQEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Is there any easy way to copy a database from MSDE to SQLServer. MSDE is
on
> the test server and we would like to copy the whole database, table data,
> structure and stored procedures.
>
Use the copy objects wizard in DTS within Enterprise Manager (if they can
see each other over the network
or
Stop the MSDE services. Copy the mdb file to the SQL Server. Use the
SP_attache_single_file_db stored procedure to attch it to the new database.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004|||Hi,
There are 2 options:-
1. Detach and Attach database
2. Backup and Restore the database
1. Detach and Attach
a. Use SP_DETACH_DB to detach the MDF and LDF files
b. Copy the files to Destination server
c. Use SP_ATTACH_DB to attach the databases
(Refer books online for information)
2. Backup and Restore
a. Backup the source databases using BACKUP DATABASE command
b. Copy the .BAK files to destination
c. Restore the database using RESTORE DATABASE command
If you have only 1 or 2 users to syncronize then use the procedure
sp_change_users_login (Refer books online)
If you have more users then; Have a look into the below link for
information.
http://www.databasejournal.com/features/mssql/article.php/2228611
Thanks
Hari
MCDBA
"Chris Kennedy" <nospam@.nospam.co.uk> wrote in message
news:OM4$mapQEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Is there any easy way to copy a database from MSDE to SQLServer. MSDE is
on
> the test server and we would like to copy the whole database, table data,
> structure and stored procedures.
>

Copy database from MSDE to SqlServer

Is there any easy way to copy a database from MSDE to SQLServer. MSDE is on
the test server and we would like to copy the whole database, table data,
structure and stored procedures."Chris Kennedy" <nospam@.nospam.co.uk> wrote in message
news:OM4$mapQEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Is there any easy way to copy a database from MSDE to SQLServer. MSDE is
on
> the test server and we would like to copy the whole database, table data,
> structure and stored procedures.
>
Use the copy objects wizard in DTS within Enterprise Manager (if they can
see each other over the network
or
Stop the MSDE services. Copy the mdb file to the SQL Server. Use the
SP_attache_single_file_db stored procedure to attch it to the new database.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004|||Hi,
There are 2 options:-
1. Detach and Attach database
2. Backup and Restore the database
1. Detach and Attach
a. Use SP_DETACH_DB to detach the MDF and LDF files
b. Copy the files to Destination server
c. Use SP_ATTACH_DB to attach the databases
(Refer books online for information)
2. Backup and Restore
a. Backup the source databases using BACKUP DATABASE command
b. Copy the .BAK files to destination
c. Restore the database using RESTORE DATABASE command
If you have only 1 or 2 users to syncronize then use the procedure
sp_change_users_login (Refer books online)
If you have more users then; Have a look into the below link for
information.
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
MCDBA
"Chris Kennedy" <nospam@.nospam.co.uk> wrote in message
news:OM4$mapQEHA.1160@.TK2MSFTNGP09.phx.gbl...
> Is there any easy way to copy a database from MSDE to SQLServer. MSDE is
on
> the test server and we would like to copy the whole database, table data,
> structure and stored procedures.
>

Copy Data to excel file using dts package in sql server 2000

Friends

Any one of you share your knowledge how to transfer data from a database to a excel using dts packages in sqlserver 2000.

I want clear steps how to create a dts package

Appreciate your help

Thanks

satish

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

You might try this group instead, as this forum is for SQL Server Integration Services

copy data from one database to another

Hi,
In our build process (where SQLServer is used as an embedded database) we always
recreate the database from scratch. When the database is recreated, the script
also recreates some basic data from the script.
Some of the QA folks are having a problem with this. They are not willing to lose all
of their existing data when a new build is invoked. I am trying to come with a simple
solution.
1. thr EM user will rename current database they have.
ALTER DATABASE OldName
MODIFY NAME = NewName
2. the build process will recreate the new database.
3. Now I need a tool to copy data from the old database. Since both old and new database
will
be in the same instance, a simple INSERT INTO TABLE(col1,col2,col3) select
col1,col2,col3
from olddatabase:table will do. What the tool should do is to disregard any dropped
columns
from being copied and set any new columns added in the newdatabase to null.
To perform step 3 is there a tool already available. I have a vague idea on how to write a
stored procedure for this, but I would prefer a tool already existing. Why reinvent the
wheel?
TIA
I think the easiest way to go about this is to use DTS. You can create a DTS
script that will do a straight copy from one database to another, specifying
which columns to skip.
|||"mmm" <mmm@.discussions.microsoft.com> wrote

>I think the easiest way to go about this is to use DTS. You can create a DTS
> script that will do a straight copy from one database to another, specifying
> which columns to skip.
The columns to skip should be automatic. I don't want to be editing DTS every
time.
I am thinking of writing a stored procedure in master database
which will use the following logic.
1. It will loop around every table of the target database where the data will go to.
2. For each table it will find out the columns and build a string as follows
INSERT INTO TARGET_DB.TABLE(COL LIST) SELECT COL_LIST
FROM SOURCE_DB.TABLE
Next the problem to tackle is the order of table. While poplating the tables
in step (1), it should populate all those tables first which either have no child tables
or child tables. That is, the sequence of loading the tables should not violate
PKY and FKY relationship.
Anyone knows a way to query tables in a database in required order mentioned above.
TIA

copy data from one database to another

Hi,
In our build process (where SQLServer is used as an embedded database) we al
ways
recreate the database from scratch. When the database is recreated, the scri
pt
also recreates some basic data from the script.
Some of the QA folks are having a problem with this. They are not willing to
lose all
of their existing data when a new build is invoked. I am trying to come with
a simple
solution.
1. thr EM user will rename current database they have.
ALTER DATABASE OldName
MODIFY NAME = NewName
2. the build process will recreate the new database.
3. Now I need a tool to copy data from the old database. Since both old and
new database
will
be in the same instance, a simple INSERT INTO TABLE(col1,col2,col3) select
col1,col2,col3
from olddatabase:table will do. What the tool should do is to disregard any
dropped
columns
from being copied and set any new columns added in the newdatabase to null.
To perform step 3 is there a tool already available. I have a vague idea on
how to write a
stored procedure for this, but I would prefer a tool already existing. Why r
einvent the
wheel?
TIAI think the easiest way to go about this is to use DTS. You can create a DTS
script that will do a straight copy from one database to another, specifying
which columns to skip.|||"mmm" <mmm@.discussions.microsoft.com> wrote

>I think the easiest way to go about this is to use DTS. You can create a DT
S
> script that will do a straight copy from one database to another, specifyi
ng
> which columns to skip.
The columns to skip should be automatic. I don't want to be editing DTS ever
y
time.
I am thinking of writing a stored procedure in master database
which will use the following logic.
1. It will loop around every table of the target database where the data wil
l go to.
2. For each table it will find out the columns and build a string as follows
INSERT INTO TARGET_DB.TABLE(COL LIST) SELECT COL_LIST
FROM SOURCE_DB.TABLE
Next the problem to tackle is the order of table. While poplating the tables
in step (1), it should populate all those tables first which either have no
child tables
or child tables. That is, the sequence of loading the tables should not viol
ate
PKY and FKY relationship.
Anyone knows a way to query tables in a database in required order mentioned
above.
TIA

copy data from one database to another

Hi,
In our build process (where SQLServer is used as an embedded database) we always
recreate the database from scratch. When the database is recreated, the script
also recreates some basic data from the script.
Some of the QA folks are having a problem with this. They are not willing to lose all
of their existing data when a new build is invoked. I am trying to come with a simple
solution.
1. thr EM user will rename current database they have.
ALTER DATABASE OldName
MODIFY NAME = NewName
2. the build process will recreate the new database.
3. Now I need a tool to copy data from the old database. Since both old and new database
will
be in the same instance, a simple INSERT INTO TABLE(col1,col2,col3) select
col1,col2,col3
from olddatabase:table will do. What the tool should do is to disregard any dropped
columns
from being copied and set any new columns added in the newdatabase to null.
To perform step 3 is there a tool already available. I have a vague idea on how to write a
stored procedure for this, but I would prefer a tool already existing. Why reinvent the
wheel?
TIAI think the easiest way to go about this is to use DTS. You can create a DTS
script that will do a straight copy from one database to another, specifying
which columns to skip.|||"mmm" <mmm@.discussions.microsoft.com> wrote
>I think the easiest way to go about this is to use DTS. You can create a DTS
> script that will do a straight copy from one database to another, specifying
> which columns to skip.
The columns to skip should be automatic. I don't want to be editing DTS every
time.
I am thinking of writing a stored procedure in master database
which will use the following logic.
1. It will loop around every table of the target database where the data will go to.
2. For each table it will find out the columns and build a string as follows
INSERT INTO TARGET_DB.TABLE(COL LIST) SELECT COL_LIST
FROM SOURCE_DB.TABLE
Next the problem to tackle is the order of table. While poplating the tables
in step (1), it should populate all those tables first which either have no child tables
or child tables. That is, the sequence of loading the tables should not violate
PKY and FKY relationship.
Anyone knows a way to query tables in a database in required order mentioned above.
TIA

Copy a view

Hi

At home i have sqlserver and at work we have sqlserver
At home i have make some views i also would like to use
on the server at work
To day i try to use import from my server to the server at work
but when i import my views the views become a table on the server at work

Is there a way to copy/import the views on from my server at home to the server at work

On my work can i connect to my server at home, so this is not the problem.

Or shall i make new views on the server at work?

Alvin

You could script the views to files (at home) and then take the scripted views to work, open them and execute and the views will get created on your work Server

In Server Management Studio, right click the view you want to script and choose

Script View >> as CREATE >> to File...

The file created will have an extension of .sql but it is a text file...

OR

If you can connect to your server from work, you can do the above, but change >> to File TO >> to New Query Editor Window and then you can cut/paste the script into your work server and execute to create the view...

|||

Thanks

Alvin

Copy a database

Hi,
I need to copy a database from sqlserver 2005 to another server sqlserver
2005 too.
I am administrador of the server source, and dbowner of a empty database
into the server destination.
Can someone help with this?
Thanks in advanceI prefer to use BACKUP DATABASE and RESTORE DATABASE for this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Vipper" <Vipper@.discussions.microsoft.com> wrote in message
news:0166FB25-A835-4901-A0D7-8CB509847B22@.microsoft.com...
> Hi,
> I need to copy a database from sqlserver 2005 to another server sqlserver
> 2005 too.
> I am administrador of the server source, and dbowner of a empty database
> into the server destination.
> Can someone help with this?
> Thanks in advance|||Hi,
If you use SQL Server logins, remember about this:
http://support.microsoft.com/kb/274188
Do you know how deal with domain users when restore database from DomainA
(logins from DomainA) to server in DomainB?
--
Regards,
anxcomp|||I like back-up restore also but you can also dettach the database, copy the
files using your operating system and then attach the copied database to
your destination instance
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Vipper" <Vipper@.discussions.microsoft.com> wrote in message
news:0166FB25-A835-4901-A0D7-8CB509847B22@.microsoft.com...
> Hi,
> I need to copy a database from sqlserver 2005 to another server sqlserver
> 2005 too.
> I am administrador of the server source, and dbowner of a empty database
> into the server destination.
> Can someone help with this?
> Thanks in advance

Copy a database

Hi,
I need to copy a database from sqlserver 2005 to another server sqlserver
2005 too.
I am administrador of the server source, and dbowner of a empty database
into the server destination.
Can someone help with this?
Thanks in advance
Hi,
If you use SQL Server logins, remember about this:
http://support.microsoft.com/kb/274188
Do you know how deal with domain users when restore database from DomainA
(logins from DomainA) to server in DomainB?
Regards,
anxcomp
|||I like back-up restore also but you can also dettach the database, copy the
files using your operating system and then attach the copied database to
your destination instance
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Vipper" <Vipper@.discussions.microsoft.com> wrote in message
news:0166FB25-A835-4901-A0D7-8CB509847B22@.microsoft.com...
> Hi,
> I need to copy a database from sqlserver 2005 to another server sqlserver
> 2005 too.
> I am administrador of the server source, and dbowner of a empty database
> into the server destination.
> Can someone help with this?
> Thanks in advance