Somehow I'm not getting dtsrun to work.
The server is local
The name of the package is ImportHosttrncs. It is saved under Local Packages.
There is no password.
Is this syntax correct?
dtsrun /Slocalhost /PImportHosttrncs
I recommend you try the DTS newsgroup microsoft.public.sqlserver.dts
-Jamie
Since VWD Express doesn't support Publish Website, I used 'Copy Website' to deploy my local site to the hosting server. The static page works fine, but when it gets to accessing database, I kept getting the following error:
An attempt to attach an auto-named database for file I:\Data\Web\dnh.sk\lingling_15726c71-b2bf-479f-bcc3-b7ae43318f3c\www\App_Data\Personal.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Anyone has the same experience? How to resolve this?
Thanks,
When you deploy your project, you have to upload your database separately.
You cannot use the db from the app_data folder. Execute the SQL against the db that you have in your hosting server and change the connectionstring for that.
Regards
|||
smiling4ever wrote:
When you deploy your project, you have to upload your database separately.
You cannot use the db from the app_data folder. Execute the SQL against the db that you have in your hosting server and change the connectionstring for that.
How do you do this when you only have VS.2005 and the basic SQL Express tools? Is it possible?
I am trying to export a databse from access into sql server express. The access database is on a network and the sql server express is on my local machine.
Could someone give me setp by step instructions please as to how to export the data from the tables into my sql server express.
Thank you very much for your time
Access includes a wizard called the Upsize Wizard that can help you do this. Depending on which version of Access you have, it may be on different menus, but last time I saw it it was under Tools | Database Utilities.
You may have to install the Upsize Wizard if you don't already have the Advanced Wizards installed. Search the Access help file for information about using this tool.
Mike
Hi guys,
I have created a new SQL database (named “DB”) on my personal pc at home.
I want to copy “DB” to my job’s computer, which works on a local net with SQL server.
What should I do?
Thanks a lot,
Aldo.
you need a connection between the machines first of. If you have VPN to your work's LAN you can use it or create a backup of the database or copy the database files in the sql server directories. If you take the offline/copy approach simply bring the file(s) via removable media into work and restore/attach the database file(s). If you can get a valid remote connection then you could use maintenance plans/SSIS to copy over the database between sql servers assuming you have valid login credentiuals to the remote "work" server.|||Hi Derek, Which / where is the file I should copy in order to get an offline copy?
I've tried copying my ".mdf" file from this path: "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\DB.mdf" but getting something strange...
Thanks in advance,
Aldo.
|||sorry, you need to detach the database first and then reattach it.|||Where can I see how to "detach" and "reatach" a dababase?|||
Hi ajliks,
I would suggest , first you take a back up of your Database (Db) from your personal pc . Copy the back up file to a CD or some portable storage device. Copy it to your Job's computer. And the restore the database from there on to your SQL Server directly. This would be the easiest way to do it.
Thanks & Regards
Mathew
|||Hi Mathew, thanks for anwering. I want to know how to make the SQL database copy. I've tried copying the mdf file but getting some strange stuff. (I want to copy the table and views configuration).
Thanks,
Aldo.
|||1. Open your SQL Server Enterprise Manager
2. Expand and Point to your database.
3. Right Click on your database (Db), and navigate to "All Task " -- "Backup Database" -- "Add" -- "File Name"
4. Give a proper file name and note the location where the backup file is being created.
5. Copy This file to your Job Computer
6. For Restoring on your Job computer check the following steps
7. Open Enterprise Manager on your job computer.
8. Point to Database Node and Right Click on "Restore Database"
9 . Type your Database Name "Db" on the drop down box "Restore Database as"
10 Navigate through "From device" -- "Select devices" -- "Add" - "File Name"
11 Select the backup file and click ok.
You would get ur database created on your machine
Does this makes sense to you now
|||Thanks a lot man!
I have to copy files from a sharepoint or extranet location (basically https://.....) location to my local server using SSIS.
Any kind of early help would be really great.
Search for Sharepoint Web Services. This is the recommended way (at least, what's been recommended to me in the past) to extract data from Sharepoint. You can use a Web Service task to access the Sharepoint web services.
http://www.developer.com/tech/article.php/3104621
I'm able to successfully do the copy from within a command window so think
the problem has something to do with using the default SQL Server account
but as yet I don't know how to resolve.
Any help/suggestions would be much appreciated.Am guessng that you are running MS-SQL using the local SYSTEM account.
System does not have access to network devices.
Your two options are to create another account and configure MS-SQL and
agent to use that account. You may beable to get away with just
configuring agent for that but depends on how you are doing the
command.
Or to go into policy editor and allowing the system account to have
netowrk priviledges. This is a major security hole and should not be
done.
Or, is there any other GUI available for MSDE?
Thanks in advance.
GrierSure. There are a few ways. A couple that come to mind are to use the sp_detach_db system stored procedure in osql, copy the database files to the server, and use sp_attach_db to reattach them. Another is to run dtsrun.exe to run a DTS package that copies it over. You could also write ADO.NET code to do it, but it would be a lot of work to get all the objects copied.
There are several tools you can use to administer MSDE:
ASP.NET Enterprise Manager, an open source SQL Server and MSDE management tool.
ASP.NET WebMatrix (which includes a database management tool) from this web site (click on the Web Matrix tab at the top of this page).
Microsoft's Web Data Administrator is a free web-based MSDE management program written using C# and ASP.NET, and includes source code.
You can also access MSDE using Access. I'm not sure if this will do what you want, though.
Any of these work for you?
Don
I am using Visual Studio 2005 to connect to a database on a remote SQL2000 server. I need to copy a table in a database on my local machine up to the server. How can I do that?
Thank you,
Do you have enterprise manager or sql management studio?
If so do use the Import/Export wizard to copy the table from A to B.
|||no - I have Access 2007 and it is nothing like Access 2000 which made this act easy
|||
Part of my problem is that I am using Vista and it is giving me fits.
|||This is "long ago at school" kind of knowledge for me. But can't u connect the sql server to your access database and copy the data across from within access?
|||Finally got it - the adp setup in Access 2007 is completely different but you are correct it does work and actually quite well - now that I learned how to use it. The brain always stops with learning incomplete.
THank you
Hi,
I am trying to use SQL Server 2005 Enterprise Edition to copy tables from my local server to my hosts server at brinkster.com. In the old version you could use DTS, but everything seems to have got far more complicated now!
Please can anybody guide me in the right direction?
Thanks a lot.
Now you can use SSIS package instead of DTS package, which can also be generated by using Import/Export Wizard as DTS
http://msdn2.microsoft.com/en-us/library/ms141134(d=ide).aspx
When you talking about copying table between servers, do you mean to copy data as well or just copy table schema? If you only want to copy table schema, you can easily do this by generating scripts for the tables on the source server: simply right click a database->choose Tasks->Generate Scripts.
If you want to copy data as well, Import/Export Wizard is your good friend; or you can backup the databases on the source server then restore from the backups on the destination; or you can even use Copy Database Wizard.
|||Thanks a lot lori_Jay, it's much easier when you know what you're looking for! It turned out I hadn't installed all the necessary components. Best to always do a full install if you have the space I guess.
Thanks again.
Quote:
Originally Posted by Motoma
If you are copying on a table by table basis, you constraints do not get copied; the server has no way of knowing if the tables referenced by the constraints are the same tables in the destination DB...The table which is referenced by constraints may not even exits!
The only way to preserve all of that information is to backup the database, and restore it on your target machine.
Quote:
Originally Posted by ajaxrand
Hi,
I need to copy some tables from my local MsSQL(2000) database to remote MSSQL server.I think I should use DTS for this purpose.
I can Connect to remote server and I cam copy the tables to it.but the problem is getting here Once I copied it Local Table Constraints not applying to the Remote Host SQL Tables. May be I am doing wrong here.
How to transfer my Table(s) with the same structure as my local host sql table(s).
Thanks!
3-if you have not any database on your remote server.you or your host administrator must create a database for your use.also you must have a user for accessing this database.
4-right click on your local database and click 'Export Data' in 'All Tasks' sub menu .then carry on with the wizard.
5-when wizard asks you the destinition database,introduce your database in your remote server.
6-in this method you replicate your database completly to your remote database server.i think you will not have such a problem for constraints.because you have a copy of data and metadata on your remote server.|||
Quote:
Originally Posted by hoomaniraji
if you do not want to programm in DTS ,then you can use enterprise manager of sql server with the following steps :
1-you should register your remote server in enterprise manager
2-you should register local server and attach the local database in the local server
3-if you have not any database on your remote server.you or your host administrator must create a database for your use.also you must have a user for accessing this database.
4-right click on your local database and click 'Export Data' in 'All Tasks' sub menu .then carry on with the wizard.
5-when wizard asks you the destinition database,introduce your database in your remote server.
6-in this method you replicate your database completly to your remote database server.i think you will not have such a problem for constraints.because you have a copy of data and metadata on your remote server.
It was a permission problem. when creating the user account for me on the SQL server, they've forgotten to assign the dbo. permission on it.The steps that I used, absolutely correct. That stupid error message which came earlier, doesn't tell anything about permissions issues. If so we could figured it out easily.
anyway, Thanks for coming here.
Hello everyone,
I have a local MSSQL server (I guess it's called MSDE), with some tables that I would like to use as a template for a set of new tables. I would simply like a Stored Procedure that takes these 3 tables, makes a copy of their structure (not data, since they will be empty), and name them by using a parameter given to the SP. I have made something that I thought would work, but after testing it a bit more, it seems to forget default values for the fields, which is of course not good enough :). I hope that someone can tell me how to duplicate these 3 tables, including every detail for the fields!
This is not really a trivial task in T-SQL. You can probablycobble something together using the INFORMATION_SCHEMA views and someheavy dynamic SQL, but it may be easier to simply hardcode the tables'DDL into your stored procedure.