Te reja dhe Aktivitete

Microsoft Visual Studio All Versions Product Keys collection

// Product Keys List //

Visual Studio has 3 primary editions now:

  • Community – Free Edition (replaced the former Microsoft Visual Studio Express, targeting students, open-source and individual developers)
  • Professional – Commercial Edition
  • Enterprise – Commercial Edition
Product Year Version Product Keys
Visual Studio 2019 2019 16.x Professional:

  • NYWVH-HT4XC-R2WYW-9Y3CM-X4V3Y

Enterprise:

  • BF8Y8-GN2QH-T84XB-QVY3B-RC4DF
Visual Studio 2017 2017 15.x Test Professional:

  • VG622-NKFP4-GTWPH-XB2JJ-JFHVF

Professional:

  • KBJFW-NXHK6-W4WJM-CRMQB-G3CDH
  • 4F3PR-NFKDB-8HFP7-9WXGY-K77T7

Enterprise:

  • NJVYC-BMHX2-G77MM-4XJMR-6Q8QF
  • N2VYX-9VR2K-T733M-MWD9X-KQCDF
Visual Studio 2015 2015 14.x Professional:

  • HMGNV-WCYXV-X7G9W-YCX63-B98R2

Enterprise:

  • HM6NR-QXX7C-DFW2Y-8B82K-WTYJV
  • 2XNFG-KFHR8-QV3CP-3W6HT-683CH

Team Foundation Server:

  • PTBNK-HVGCM-HB2GW-MXWMH-T3BJQ
Visual Studio 2013 2013 12.x Professional:

  • XDM3T-W3T3V-MGJWK-8BFVD-GVPKY

Premium:

  • FBJVC-3CMTX-D8DVP-RTQCT-92494

Ultimate:

  • BWG7X-J98B3-W34RT-33B3R-JVYW9

Team Foundation Server:

  • MHG9J-HHHX9-WWPQP-D8T7H-7KCQG
Visual Studio 2012 2012 11.x Professional:

  • 4D974-9QX42-9Y43G-YJ7JG-JDYBP

Premium:

  • MH2FR-BC9R2-84433-47M63-KQVWC

Ultimate:

  • YKCW6-BPFPF-BT8C9-7DCTH-QXGWC
  • RBCXF-CVBGR-382MK-DFHJ4-C69G8
  • YQ7PR-QTHDM-HCBCV-9GKGG-TB2TM
  • MMVJ9-FKY74-W449Y-RB79G-8GJGJ
  • YCFHQ-9DWCY-DKV88-T2TMH-G7BHP

Team Foundation Server:

  • BVGTF-T7MVR-TP46H-9Q97G-XBXRB
Visual Studio 2010 2010 10.x Professional/Ultimate (built-in or below):

  • YCFHQ-9DWCY-DKV88-T2TMH-G7BHP
Visual Studio 2008 2007 9.x Express: Not requiredProfessional:

  • XMQ2Y-4T3V6-XJ48Y-D3K2V-6C4WT
  • WPX3J-BXC3W-BPYWP-PJ8CM-F7M8T
  • PYHYP-WXB3B-B2CCM-V9DX9-VDY8T
  • WPDW8-M962C-VJX9M-HQB4Q-JVTDM
Visual Studio 2005 2005 8.x Express: Not requiredStandard: Not required

Professional:

  • KGR3T-F2C26-RRTGT-D6DQT-QBBB3
Visual Studio 6.0 1998 6.x
  • 111-1111111
  • 0123456789
  • 1234567890
Microsoft SQL Server
SQL Server 2008 Developer Edition:PTTFM-X467G-P7RH2-3Q6CG-4DMYB

Enterprise Edition:

JD8Y6-HQG69-P9H84-XDTPG-34MBB

SQL Server 2008 R2 Developer Edition (32-bit):MC46H-JQR3C-2JRHY-XYRKY-QWPVM

Developer Edition (64-bit):

FTMGC-B2J97-PJ4QG-V84YB-MTXX8

Data Center Edition (32-bit):

PTTFM-X467G-P7RH2-3Q6CG-4DMYB

Data Center Edition (64-bit):

DDT3B-8W62X-P9JD6-8MX7M-HWK38

Enterprise Edition (32-bit):

R88PF-GMCFT-KM2KR-4R7GB-43K4B

Enterprise Edition (64-bit):

GYF3T-H2V88-GRPPH-HWRJP-QRTYB

Standard Version (32-bit):

CXTFT-74V4Y-9D48T-2DMFW-TX7CY

Standard Edition (64-bit):

B68Q6-KK2R7-89WGB-6Q9KR-QHFDW

Working Group Edition:

XQ4CB-VK9P3-4WYYH-4HQX3-K2R6Q

WEB Edition:

FP4P7-YKG22-WGRVK-MKGMX-V9MTM

SQL Server 2012 Enterprise Core Edition: FH666-Y346V-7XFQ3-V69JM-RHW28

Business Intelligence Edition:

HRV7T-DVTM4-V6XG8-P36T4-MRYT6

Developer Edition:

YQWTX-G8T4R-QW4XX-BVH62-GP68Y

Enterprise Server/CAL Edition:

748RB-X4T6B-MRM7V-RTVFF-CHC8H

Standard Edition:

YFC4R-BRRWB-TVP9Y-6WJQ9-MCJQ7

Web Edition:

FB3W8-YRXDP-G8F8F-C46KG-Q998F

SQL Server 2012 R2 Developer Edition:YQWTX-G8T4R-QW4XX-BVH62-GP68Y
SQL Server 2014 Web Edition: J9MBB-R8PMP-R8WTW-8JJRD-C6GGW

Standard Edition:

P7FRV-Y6X6Y-Y8C6Q-TB4QR-DMTTK

Developer Edition:

82YJF-9RP6B-YQV9M-VXQFR-YJBGX

Enterprise Edition:

27HMJ-GH7P9-X2TTB-WPHQC-RG79R

Enterprise Core Edition:

TJYBJ-8YGH6-QK2JJ-M9DFB-D7M9D

Business Intelligence Edition:

GJPF4-7PTW4-BB9JH-BVP6M-WFTMJ

SQL Server 2016 Enterprise Edition:MDCJV-3YX8N-WG89M-KV443-G8249

Enterprise Core Edition:

TBR8B-BXC4Y-298NV-PYTBY-G3BCP

Standard Edition:

B9GQY-GBG4J-282NY-QRG4X-KQBCR

Web Edition:

BXJTY-X3GNH-WHTHG-8V3XK-T8243

Schedule Shutdown or Restarts in Windows using the Task Scheduler

While you can always use the Shutdown /s /t 60 command and create a desktop shortcut to delay shutdown of your Windows 10/8/7 computer by (in this case 60 secs) or make it shutdown at a particular time after calculating the time in seconds, you can also use the Task scheduler to shut down, restart or perform any action at one time or periodically.

Schedule Shutdown or Restarts in Windows

Using the Task Scheduler, you can schedule computer to shut down at a certain time in the night or any time! And why might you want to do this? Maybe your computer is processing a task or maybe it is downloading files from the Internet, and you do not want to wait till then. You can then schedule it to shut down after say 2 hours, while you go on to catch up on your beauty sleep!

To make your computer shutdown at a particular time, type taskschd.msc is start search and hit Enter to open the Task Scheduler. In the right panel, click on Create Basic Task.

Give it name and a description if you wish and click Next.

When asked When do you want the task to start, select One time. Click Next.

Select the Start date and time.

Clicking Next will bring you to the Action page. Here select Start a program and click on Next.

Here type shutdown on the Program/script space and /s /f /t 0 in the Add arguments box. If you want the shutdown to commence after say 60 sec, type 60 instead of 0 here.

Click Next to review all and finally click Finish. Your computer will shutdown at the designated day and time.

NOTE: In a CMD window, you may run shutdown /? to see all the available switches. To schedule restarts, you need to use the /r parameter instead of the /s parameter. To log off the current user use /l.

If you are looking out for faster ways to do it, take a look at some of these free tools to Auto Shutdown, Restart Windows computer at fixed times.

VMWare Workstation 9 & 10

VMWare Workstation 9 Keys:

HA2VM-220EP-3ZAN8-JR156-8CNHD
1V6JV-60H84-LZXV0-028G2-CA2HD
0V0HD-641E4-FZWK0-UH1EM-CAEP1
NG25P-AW2DN-RZ1V0-K8252-ACY0P
1V22N-4LK8H-TZ1N9-GR9Q2-92GK5

VMWare Workstation 10 Keys:

1Z0G9-67285-FZG78-ZL3Q2-234JG
4C4EK-89KDL-5ZFP9-1LA5P-2A0J0
HY086-4T01N-CZ3U0-CV0QM-13DNU
5U4GA-DQ09H-EZK48-YTAQP-83K79
NU4FQ-DFH40-0ZA01-8A37K-32RKL
HF0DA-FF086-VZ739-AA87H-236M4
HF0A8-FMJ1P-1Z1U1-LK1N2-9AGKJ
5A477-D3284-3ZUF0-2K154-23R0P
MY47Y-2MK1M-6ZQC0-7J05M-8A60D
5V6K2-29243-HZDV0-VVA76-93A2R
NA28T-DR114-AZ9Z8-R1250-93U27
MF4JG-4H3DK-NZ3L0-KHCNM-8AMNP
NA6F3-2HKEM-6ZDF8-Q18N6-33DNN
1Y2FZ-AHJ5H-6ZU09-DKA5M-82RQ7
5U6KQ-6M240-LZMW1-U13N2-AAX7X
HA4FW-8G052-DZ8Q0-U295P-83KLV
5F4PK-42181-9ZXP9-T31Q6-1CVKM
JY468-44L9M-DZ479-3UA72-CAKHR
4F6Z5-80H42-FZ889-L007M-ACJJN
5F6E9-DHL4J-HZ640-KLA70-8C0NN

Serial key of vmware workstation 9.0.1:
4A62F-FU00N-VZM78-ZKCQK-8297E
NA2Y9-2ALE1-3ZNX1-10CQ4-0CK77
HU047-DYKE4-ZZPQ8-L02QH-1AZ4W
JZ422-4AKDN-3ZKV8-G2A5P-827PK
4F2MR-D92EH-GZNV8-YLA7H-13YM9
NF6HV-D435L-XZPD9-J817K-CCN58
4Z6C4-DR1E6-KZ4U0-0K15H-0CFPK
JC0ZU-0H150-3ZTR9-DT15P-02N2K
MA2UX-D614Q-CZ7H1-MACN4-82TQZ
JG6UD-4RH9P-GZP59-9V25K-02TP6
MU0XV-F70D7-3ZW58-FH072-1AP59
1F6VP-AQ20J-GZ4U0-NT17P-8305J

MikroTik Schedule Auto Reboot Script every day at 6 AM

So you want to have your MikroTik router rebooted every day at 6 a.m. in the morning before the business start to prevent possible random issues from happening?

Go to MikroTik Winbox, open a New Terminal and enter this one line simple command:

Code:
/system scheduler add name="reboot-6am" start-date="jan/17/2017" start-time="06:00:00" interval="1d" on-event="/system reboot"

Migration From SQL Server To Oracle Using SQL Developer

Migration is the process of copying the schema objects and data from a non-Oracle database, such as MySQL, Microsoft SQL Server, Sybase Adaptive Server, Microsoft Access, or IBM DB2, to an Oracle database.

To migrate a third-party database to Oracle easily, you can choose the following options using SQL Developer:

– Migrating using the Migration Wizard

– Copying tables to Oracle

Migrating Using the Migration Wizard

The Migration wizard provides a screen to manage all the steps needed for the migration to Oracle database. These steps are as follows:

– Capturing the source database (MySQL, Microsoft SQL Server, Sybase Adaptive Server, Microsoft Access, IBM DB2),

– Converting it to Oracle format,

– Generating DDL,

– Performing the conversion.

After a brief explanation about the process of migration, let’s do a simple migration from SQL Server database to Oracle database.

1- I created sample SQL Server database named TALIPTEST.

2- The migration repository is a collection of schema objects that SQL Developer uses to manage metadata for migrations. For a migration repository create a database connection to convenient Oracle database and give following grants.

 CREATE USER MIGRATIONS IDENTIFIED BY “migration”

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE TEMP;

grant create session to migrations;

grant resource to migrations;

grant create view to migrations;

For multischema migrations, you must grant the privileges with the ADMIN option as follows.

grant resource to migrations with admin option;

grant create role to migrations with admin option;

grant alter any trigger to migrations with admin option;

grant create user to migrations with admin option;

3- Download SQL Developer from http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

4- Unzip the file named sqldeveloper-3.2.20.09.87.zip and extract it. Open  sqldeveloper.exe file to open SQL Developer.

5- Right click to the “Connections” and click the “New Connections”

6-  Create a database connection named Migration_Repository that connects to the MIGRATIONS user.

7- Right-click the Migration_Repository connection, and select “Migration Repository” menu , then “Associate Migration Repository” to create the repository.

8- Schema objects needed for migration will be created in MIGRATIONS schema.

9- To connect to third-party database (MySQL, Microsoft SQL Server, Sybase Adaptive Server,  Microsoft Access, IBM DB2) using SQL Developer, we need jTDS driver. You can download needed jTDS driver from following link. http://sourceforge.net/projects/jtds/files/jtds/1.2/jtds-1.2-dist.zip/download  . Extract the dowloaded zip file named jtds-1.2-dist.zip

10- Click “Tools” and then “Prefenrences”.

11- Select “Third Party JDBC Drivers” and click “Add Entry” button to add jTDS driver for SQL Server.

12- Select jar file located in jTDS driver folder.

13- Click “OK” button.

14- Now you can connect to SQL Server or Sybase database using SQL Developer. Connect to the SQL Server database as follows.

15- And finally, let us create the database connection which we will migrate to.

16- The migration wizard is invoked in a variety of contexts. You can right-click a third-party database connection and select “Migrate to Oracle”  or you can click “Tools>Migration>Migrate…”.

17- Click “Next” button.

18- Select migration repository database connection.

19- Give a name for migration project and select a directory to write output.

20– Select third party database connection. You can migrate database on online or offline mode. If you choose online migration then Migration Wizard will perform all needed operations. If you choose offline migration then Migration Wizard will generate all needed DDL scripts.

21- Select SQL Server database which we want to migrate to Oracle.

22- Specify the conversion options. And click “Advanced Options” link to ensure “Microsoft SQL Server : Is quoted identifier on” option is selected.

23- Select target database connection.

24- If you select offline migration then offline migration script will be generated in the project output directory.

25- Select the connections to be used for online data move.

26- Click “Finish” button so start migration.

27- Migration and conversion process will be perfomed as follows.

Now, Our SQL Server database in Oracle 🙂

Copying tables to Oracle

Right click the table located in third party database and click “Copy To Oracle”

Select destination (Oracle) database connection and click “Apply” button. If you choose “Include Data” check box it will create table structure and move data.

Copy to Oracle database is finished.

Note: This method doesn’t move indexes, triggers, etc. It only moves table structure and data.

Data Type Conversion

Data Type Conversion

The gateway converts Microsoft SQL Server data types to Oracle data types as follows:

Table A-1 Data Type Conversions

Microsoft SQL Server Oracle Comment
BIGINT NUMBER(19)
BINARY RAW
BIT NUMBER(3)
CHAR CHAR
DATETIME DATE Fractional parts of a second are truncated
DECIMAL NUMBER(p[,s])
FLOAT FLOAT(49)
IMAGE LONG RAW
INTEGER NUMBER(10) NUMBER range is -2,147,483,647 to 2,147,483,647
MONEY NUMBER(19,4)
NCHAR NCHAR
NTEXT LONG
NVARCHAR NCHAR
NUMERIC NUMBER(p[,s])
REAL FLOAT(23)
SMALL DATETIME DATE The value for seconds is returned as 0
SMALL MONEY NUMBER(10,4)
SMALLINT NUMBER(5) NUMBER range is -32,767 to 32,767
TEXT LONG
TIMESTAMP RAW
TINYINT NUMBER(3)
UNIQUEIDENTIFIER CHAR(36)
VARBINARY RAW
VARCHAR VARCHAR2

Bitrix 24 – Corporate Portal 18.5.180

1C-Bitrix Corporate Portal 18.5.180.tar.gz
Rename and unpack the distribution archive in the ssh command line or using the hosting control panel with the command:
tar xzvf bitrix24_source.tar.gz
2. In the browser, run http: //name-your-site.ru/index.php
3. Follow the instructions of the installer;
4. On the encoding selection screen, ALWAYS select the UTF-8 encoding;
5. When you get to the license entry field – enter PTR-ML-BXPR18XXXXXXXXXX – instead of “X”, any numbers or capital Latin letters.
6. Follow the instructions of the installer.
7. Profit !!

query in the database

INSERT INTO `b_option` (` MODULE_ID`, `NAME`,` VALUE`, `DESCRIPTION`,` SITE_ID`) VALUES
(‘main’, ‘PARAM_MAX_SITES’, ‘ 2 ‘, ”, NULL),
(‘main’ , ‘PARAM_MAX_USERS’, ‘ 100500 ‘, ”, NULL);

Free Web Hosting