February 2, 2016 at 1:02 pm
Hi All,
I got one task where I need to bring data from SQL server which is on citrix server to our local sql server. We have only access to management studio on citrix and I am able to open and connect to database. But Task is need to bring that database in our local. I don't know how to bring data into our local system (management studio) from citrix server.
Please let me know, if any one have idea
Thanks
Bhavesh
February 2, 2016 at 3:32 pm
Backup /restore?
February 2, 2016 at 4:26 pm
Thanks for your reply.
Well ,Backup and restored that was my first though .But we would like to use on daily basis.
I don't know, where is the citrix server.
Do we need to find out , what is the location for Citrix Server ?
Thank
Bhavesh
February 2, 2016 at 10:41 pm
I guess i am not clear on your question. If you need on daily basis can u just set up a scheduled daily backup job?
February 5, 2016 at 4:57 am
Hi Bhavesh, Looks like you are connecting to machine via citrix where SQL server is installed .
You can simple take copy only backup in case if it is PROD, transfer it to shared location and then copy that on local server (server where you need to install).
Sagar Sonawane
** Every DBA has his day!!:cool:
February 5, 2016 at 6:45 am
patla4u (2/2/2016)
Hi All,I got one task where I need to bring data from SQL server which is on citrix server to our local sql server. We have only access to management studio on citrix and I am able to open and connect to database. But Task is need to bring that database in our local. I don't know how to bring data into our local system (management studio) from citrix server.
Please let me know, if any one have idea
Thanks
Bhavesh
Hi Bhavesh,
Keep in mind that SQL Server Management Studio is just a GUI and it could be installed on a (Citrix-)server without the SQL Database engine. From SSMS you can connect to any server where the database engine is running, for as far firewall and permissions are set correctly. So it could easily be that the database you are connecting to is not on the Citrix server where you have started SSMS.
So first of all: you'll need to know the servername of the database you connect to (i.e. source server; you mention connect from Citrix). Next you'll need to know the servername of the database server where you want to copy the data to (i.e. target server; you mention as local server). On the source server you can create and schedule a job that creates a backup of the database. Let it create a backupfile to a general location (share) where you have access to from both the source and the target server. On the target server you can setup and schedule a job to restore the database using the backup file on the share.
Keep the name of the backupfile unchanged for each backup taken, just replace the existing file. That way you can create a fixed BACKUP and RESTORE command without the need to dynamically use a different backupfilename each time. Restore the database using the WITH REPLACE option to overwrite the existing database. Keep sufficient time between the start of the backup and the start of the restore. You cannot start the restore untill the backup is finsished.
If you don't want to copy the complete database over from the source to the target server you can look at creating a SSIS package to only copy selected tables/rowsets between the databases.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply